This shows you the differences between two versions of the page.
reading_20and_20writing_20csv_20files [2018/03/31 14:19] 127.0.0.1 external edit |
reading_20and_20writing_20csv_20files [2018/04/17 19:25] (current) tbest3112 Added syntax highlighting |
||
---|---|---|---|
Line 12: | Line 12: | ||
1999,Chevy,"Venture ""Extended Edition""",,4900.00 | 1999,Chevy,"Venture ""Extended Edition""",,4900.00 | ||
For more details see this [[http://en.wikipedia.org/wiki/Comma-separated_values|Wikipedia article]].\\ \\ The routines listed below read a CSV file into a 2D string array or write a 2D string array into a CSV file respectively. Note that spaces before an initial quote character are not permitted. If the CSV file uses a non-standard line termination (e.g. **LF** or **LFCR**) then replace the **INPUT #F%,A$** with **A$ = FNreadline(F%)** where the FNreadline function can be found in this [[/Reading%20and%20writing%20plain%20text%20files|article]].\\ \\ | For more details see this [[http://en.wikipedia.org/wiki/Comma-separated_values|Wikipedia article]].\\ \\ The routines listed below read a CSV file into a 2D string array or write a 2D string array into a CSV file respectively. Note that spaces before an initial quote character are not permitted. If the CSV file uses a non-standard line termination (e.g. **LF** or **LFCR**) then replace the **INPUT #F%,A$** with **A$ = FNreadline(F%)** where the FNreadline function can be found in this [[/Reading%20and%20writing%20plain%20text%20files|article]].\\ \\ | ||
+ | <code bb4w> | ||
DEF PROCreadCSV(file$,array$()) | DEF PROCreadCSV(file$,array$()) | ||
LOCAL F%,R%,C%,I%,A$,C$ | LOCAL F%,R%,C%,I%,A$,C$ | ||
Line 70: | Line 71: | ||
CLOSE #F% | CLOSE #F% | ||
ENDPROC | ENDPROC | ||
+ | </code> |