Commands & Syntax > Commands > File Mainpulation >

CSV Load - < csv_file_load >() ... [Pro]

www.perfectkeyboard.com

 

File CSV Load
<csv_file_load>("File path",File handle variable)
Available in: Professional edition

This command loads CSV file data. When data are loaded then "get record" command can be used in a loop to get fields for each record.

 

#

Parameter name

Parameter description

1

File path

(Full) path to the input CSV file.

2

File handle variable

Variable that receives CSV file handle. This variable is used as input parameter to "get record" command.

 

Example (Macro Steps):

 

1

<#> <#> This example shows how to parse CSV file

2

Macro execution: ONLY COMMANDS

3

<#> <#>Load CSV file

4

File CSV Load c:\data\file1.csv, File handle variable = vCsvFile,%p3_name =

5

<#> <#>Read all records in loop

6

Repeat steps UNTIL "1" (Counter variable initial value = "i=0", Counter loop increment = "1")

7

File CSV Get Record Fields (File handle variable = "vCsvFile", Variable array for fields = "vFields", Variable for number of fields = "vFieldsNum")

8

IF %vFieldsNum%<=0

9

<#> <#>No more records to process

10

Repeat steps BREAK

11

ENDIF

12

Repeat steps UNTIL "%r%