LoadCsvFile

Takes two parameters, FileName, bHasHeader

Usage:

FileName, bHasHeader
FileName, ["y"]

Description:

Given a local file name path, it is parsed into the WorkQuery using CRLF characters for Records and commas for Fields.

As an optimization, this command does not correctly parse whitespace within a field, or handle quotes within quoted fields. Only use this command if the data is from a trusted source and these limitations are not an issue. For general purposes, the LoadCsvFileWS command should be used instead.

This command applies both AnsiToUtf8$ and WebSafe$ to the data during the loading process. If these conversions are not desired, use a combination of LoadFile$ and CsvStream or CsvStreamWS instead.

Example:

LoadCsvFile "Private/someData.csv"