LFinString option

Specifies whether an embedded newline value that is also the record delimiter is treated as real data.

Acceptable values are true or false. The default value is false. Do not put quotation marks around the value.

By default, the newline value is the record delimiter. You can change the record delimiter to another value by using the -recDelim option.

If the value of the LFinString option is true and the record delimiter is the newline value, the following behavior applies, regardless of the setting of the FillRecord option:
  • If the newline value is not in the last record of the field, the newline value is treated as real data.
  • If the newline value is in the last record of the field, the newline value is treated as the record delimiter unless you escape it.

The LFinString option applies only to data loads. It has no effect on data unloads. This option is not supported for the fixed-length format.