|
CSV= comma-separated values in output files = No |
Top Up Down
A A |
To facilitate importing the IFILE=, ISFILE=, PFILE=, SFILE= and XFILE= files into spreadsheet and database programs, the fields can be separated by commas, and the character values placed inside " " marks.
CSV=No or Fixed |
Use fixed field length format (the standard) (.txt) |
CSV=Yes or CSV=, |
Separate values by commas (or their international replacements). If QUOTES=Yes, character fields in " " marks |
CSV=Tab or CSV= |
Separate values by tab characters. If QUOTES=Yes, character fields in " " marks |
CSV=SPSS |
SPSS format (.sav) |
CSV=Excel or XL |
Excel format (.xls, .xlsx) |
CSV=Rstat |
R-statistics format (.rda) |
CSV=Webpage |
Webpage format (.htm, .html) |
Examples:
Fixed space:
; MATCH Chess Matches at the Venice Tournament, 1971 Feb 11 0:47 2004
;ENTRY MEASURE STTS COUNT SCORE ERROR IN.MSQ IN.ZSTD OUT.MS OUT.ZSTD DISPL PTME WEIGHT DISCR G M NAME
1 .87 1 2.0 2.0 .69 1.17 .47 1.17 .47 .01 1.00 1.00 1.97 1 R I0001
Tab-delimited:
"MATCH Chess Matches at the Venice Tournament, 1971 Feb 11 0:47 2004"
";" "ENTRY" "MEASURE" "STATUS" "COUNT" "SCORE" "ERROR" "IN.MSQ" "IN.ZSTD" .....
" " 1 .87 1 2.0 2.0 .69 1.17 .47 1.17 .47 .01 1.00 1.00 1.97 "1" "R" "I0001"
Comma-separated:
"MATCH Chess Matches at the Venice Tournament, 1971 Feb 11 0:47 2004"
";","ENTRY","MEASURE","STATUS","COUNT","SCORE","ERROR","IN.MSQ","IN.ZSTD",....
" ",1,.87,1,2.0,2.0,.69,1.17,.47,1.17,.47,.01,1.00,1.00,1.97,"1","R","I0001"
SPSS format: This is the SPSS .sav file format.