Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
LOAD DATA INFILE allows the user to change field and record separators and to ignore header lines. This allows reading files that CONNECT cannot read.
For example, this variation on CSV can be read with
load data infile ...
|
fields terminated by 0x01
|
lines terminated by 0x020A
|
ignore 34 lines
|
Please add this flexibility also to CONNECT CSV to expand its applicability.
(Note: the record separator in this example is 2 bytes long.)