1. ZPL II, ZBI 2, Set-Get-Do, Mirror, WML Programming Guide
  2. ZBI Commands
  3. CSVLOAD
  • ZPL II, ZBI 2, Set-Get-Do, Mirror, WML Programming Guide
CSVLOAD

CSVLOAD

This function will load the delimited values from a CSV file, defined by
FILENAME$
, and store them in the two-dimensional array,
DEST$
.
Format
CSVLOAD(DEST$, FILENAME$)
CSVLOAD(DEST$, FILENAME$, DELIM$)
Parameters
DEST$
 = two dimensional array that will hold the rows and columns from the CSV file specified by the
FILENAME$
 variable. If there is not enough room in
DEST$
, or if it has the wrong size, it will be changed to fit the data from the file. The data originally in
DEST$
 will be overwritten.
FILENAME$
 = name of the file to load. Drive location and file name must be in quotation marks. The file extension must be either "
.CSV
" or "
.TXT
".
DELIM$
 = optional delimiter that is used in the CSV file instead of a comma. If
DELIM$
 is not provided a comma will be used by default. The delimiter must be a single character that is not a quote, carriage return, or newline.
Returns
The number of elements in each row of the CSV file. The function will return 0 if errors were detected in the CSV file, or if the file could not be read.
Example
This example shows how to print the values in a CSV file with a comma delimiter. 
10  DECLARE STRING CSVDB$(1,2) 
20  LET FILENAME$ = "E:RECORDS.CSV" 
30  LET NUMOFCOLS = CSVLOAD(CSVDB$, FILENAME$) 
40  LET NUMOFROWS = ROWSIZE(CSVDB$) 
100 FOR I = 1 TO NUMOFROWS STEP 1 
110     FOR J = 1 TO NUMOFCOLS STEP 1 
120         PRINT CSVDB$(I, J), " "; 
200     NEXT J 
210     PRINT ""  
300 NEXT I
Example
This example shows how to print the values in a CSV file that uses a '|' as a delimiter. 
10  DECLARE STRING CSVDB$(1,2) 
20  LET FILENAME$ = "E:EMPLOYEE.CSV" 
30  LET NUMOFCOLS = CSVLOAD(CSVDB$, FILENAME$, "|") 
40  LET NUMOFROWS = ROWSIZE(CSVDB$) 
100 FOR I = 1 TO NUMOFROWS STEP 1 
110     FOR J = 1 TO NUMOFCOLS STEP 1 
120         PRINT CSVDB$(I, J), " "; 
200     NEXT J 
210     PRINT ""  
300 NEXT I
Comments
The maximum CSV file size supported will vary based upon available RAM within the printer.