LoadPipeFile

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 | characters for Fields. The file used with this function should be of a .txt, .psv extension.

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 LoadPipeFileWS command should be used instead.

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 PipeStream or PipeStreamWS instead.

Example:

LoadPipeFile "Private/someData.psv"