Administrative functions > Data conversion programs > Convert tables into comma-delimited ASCII format > Default output style
 
Default output style
When q2cda or qvq2cda reads a Quantum or Quanvert Text table, it takes each non-blank line in the table and converts it into a list of texts and/or numbers separated by commas and writes it out to an output file. Texts are enclosed in double quotes. Thus, the row:
Base   173   34   139
becomes
"Base",173,34,139
The exception is the column headings of the table which, if created by g and p statements, are not enclosed in double quotes. If column headings are created automatically from n01/col/val/bit statements, each entry is enclosed in double quotes.
Blank lines anywhere before the first row of the table are treated as empty text lines and appear as two consecutive double quotes at the start of the next text row in the table. If there is more than one blank line, the text line starts with as many empty entries as there are blank lines. Lines of the form:
""
""
"","Base   Male   Female"
define a set of column headings. The two empty entries represent two blank lines before the column headings. The empty entry at the beginning of the third line is the row text (which is blank) before the column headings. The empty entry at the end of the line indicates that there is a blank line between the column headings and the first row of the table.
Blank lines within the table (for example, if it has been created double spaced) are ignored.
When a row in the table consists of more than one type of figures (for example, absolutes and column percentages), the row text for the percentage lines is often blank. This is treated as a blank text area and the entry in the output file will therefore start with two consecutive double quotes.
When the table contains percentages, these appear as a row of numbers without percentage signs.
Example
                                                       Page 1
London Shopping Survey
                                    Absolutes/col percentages

                         Base            Male         Female

Base                      173              34            139
North                      59              10             49
                         34.1%           29.4%          35.3%
South                      49              11             38
                         28.3%           32.4%          27.3%
East                        3               6             24
                          1.7%           17.6%          27.3%
West                       35               7             28
                         20.2%           20.6%          20.1%
Processing with q2cda or qvq2cda produces a comma-delimited ASCII file as follows:
"London Shopping Survey"
"#page"
"Absolutes/col percents"
""
""
"","Base            Male         Female"
"Base",173,34,139
"North",59,10,49
"",34.1,29.4,35.3
"South",49,11,38
"",28.3,32.4,27.3
"East",3,6,24
"",1.7,17.6,17.3
"West",35,7,28
"",20.2,20.6,20.1
The page number is always shown as #page for every table and it appears after the table title, whereas in Quantum the page number precedes the title.
See also
Convert tables into comma-delimited ASCII format