On this BASIC, internal record type files are CSV files, which are commonly used on spreadsheets.
One line of a CSV file is one record of an internal record type file.
That is, one execution of a WRITE or READ statement carries out output or input of one line of a CSV file.
Outputs data on arrays declared with
DIM s$(10), h(10), w(10) to a CSV file.
The file output can be read as a table of 3 columns, 10 rows in spreadsheets.
OPEN #1:NAME "A:DATA.CSV",RECTYPE INTERNAL ERASE #1 FOR i=1 TO 10 WRITE #1:s$(i),h(i),w(i) NEXT i CLOSE #1
Conversely, the following program reads CSV table data of 3 columns, 10 rows into BASIC.
DIM s$(10), h(10), w(10) OPEN #1:NAME "A:DATA.CSV",RECTYPE INTERNAL FOR i=1 TO 10 READ #1:s$(i),h(i),w(i) NEXT i CLOSE #1
When an originally enhanced syntax RECTYPE CSV is written, array input and output are changed to be suited to cooperation with spreadsheet software.
For example, when an array A is defined in DIM A(10,4), the following generates 10 lines each of which has 4 numeric values separated by commas.
OPEN #1:NAME "A:DATA.CSV",RECTYPE CSV ERASE #1 MAT WRITE #1:A CLOSE #1
Furthermore, the following loads numeric data recorded with that form to the array.
OPEN #1:NAME "A:DATA.CSV",RECTYPE CSV MAT READ #1:A CLOSE #1
Note. RECTYPE CSV is the same as RECTYPE INTERNAL if no array input or output is executed.