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 (or just LF) characters for Records and commas for Field
The WS on this command denotes that it parses whitespace and quotes within quoted fields correctly. There is a performance overhead from handling this, but the tradeoff should be accepted for all general purpose use cases. If the data will only ever come from a trusted source and these aspects are not required, consider using the LoadCsvFile command.
This command applies both BomToUtf8$ 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:
LoadCsvFileWS "Private/someData.csv"