<< Click to Display Table of Contents >> Navigation: Reference > RCPs > CSV2 [EFnGILMOnPnRZ] |
This Run Control Parameter causes tables to be output to a comma-separated file with the suffix .CSV during the Print Step.
The CSV2 can be followed by any combination of the following:
•E which causes empty marker columns to be output as a single blank character
•G which causes format FSL table footnote rows to be suppressed and the FSL text to be added to the end of the global footer
•I which causes an information line to be output for each new table definition, see CSV identifiers (first column)
•L which causes an extra CM row to be created after the column labels for the column identifiers used for statistics. The identifiers (letters in parentheses) are removed from the end of the column label text
•M which causes a separate marker column to appear alongside each column with the markers in it instead of appearing in a separate row
•R which causes all values to be rounded as shown on the tables.
•Z which causes formats CAZ, CNZ, and CZP to be used in the CSV tables output.
There are three additional controls which can be set using a letter followed by a number:
•Fdp which rounds raw figures to the set number of decimal places. The dp value must be between 1 and 14.
•Pdp which rounds percentages to the set number of decimal places. The dp value must be between 1 and 14.
•Odp which rounds statistics (other) to the set number of decimal places. The dp value must be between 1 and 14.
These three settings will be ignored if R is used. The purpose of these settings is make the cell values easier to read when clicked.
WARNING: Using these three settings will cause double rounding of displayed cells if the decimal places set by formats is less than these settings. Rounding twice can cause figures which are just below 0.5 to be rounded up when they should have been rounded down. Using more decimal places will reduce the double rounding problem.
IMPORTANT: If G is used then formats SLA, SLB, SLC and SLD must not be changed during the run. If they are changed then the CSV output will be stopped and an error message issued.
Note that tables will also be output to the Tables file unless RCP NOTAB is set.
The RCP replaces RCPs MAT and CSV[PMTF] which are are now obsolete.
The first column of the output file identifies the line contents, see CSV identifiers (first column) .
Examples:
CSV2
CSV2G
CSV2I
CSV2L
CSV2M
CSV2R
CSV2GL
CSV2GILMR
CSV2P2
CSV2LP2F4O10