|
<< Click to Display Table of Contents >> Navigation: Reference > RCPs > CSV identifiers (first column) |
These identifiers are placed in column 1 of Tables CSV output using RCP CSV2.
They are intended to facilitate the writing of macros to enhance the output after loading to a spreadsheet program.
Initial letter(s) |
Contents |
BE |
Start of file |
JH |
Header |
JF |
Footer |
|
|
TB |
Start of table |
|
|
IT |
Identifier title |
VT |
Vertical title |
HT |
Horizontal title |
BT |
Base title |
|
|
CH |
Col label header |
CI |
Col label over header |
CJ |
Col label super header |
CU |
Unweighted col label |
CT |
Total col label |
CL |
Col label |
CM |
Col identifiers (if RCP CSV2 L used) |
|
|
IN |
table number, number of rows, number of columns, page number actual, page number printed, table type, and formats for table |
|
|
RH |
Row label header |
RI |
Row label super or over header |
RU |
Unweighted row label |
RT |
Total row label |
RW |
Row label |
RS |
Stats row label |
|
|
RC |
Figures |
PV |
Vertical percentages |
PH |
Horizontal percentages |
MK |
Markers |
BL |
blank lines |
|
|
FT |
Footnote title |
TE |
Table ends |
|
|
EN |
End of file |
The job header and footer are only output once at the beginning of the Tables CSV file (after the BE line).
SZ and TF lines are no longer produced.
Tables combined with +t (format CON) will be combined.
Honour row and column suppression.
Honour other relevant label controls in row and column labels.
The table number of the TB line is the printed table number.
Formats NPVT, NPHT, and NPBT are honoured - they suppress the relevant rows.
Format NTID suppresses the table number (but not the TB line itself).
Optional (R) to round all figures to match tables output.
Optional (M) to put out double columns with markers in the second of each pair.
Optional IN (information) lines contain the following information for each input table:
•Table number (#name)
•Number of rows (figures plus stats)
•Number of columns
•Page number (actual)
•Page number (printed)
•Table type (STA, VDT, DIS)
•Format options