Ignore Linefeeds in MLoad from Flat File

Tools & Utilities

Ignore Linefeeds in MLoad from Flat File

I have data exported from oracle to a pipe delimited flat file with some fields spanning to multiple lines which is causing an issue in MLoad whereby linefeeds are present in the data causing MLoad to fail.

Is there a command (or method) within MLoad that will allow our script to ignore the linefeeds between delimiters within the flat file?
1 REPLY
Junior Supporter

Re: Ignore Linefeeds in MLoad from Flat File

The export method should replace the 0x0A with some code using Oracle REPLACE() function in order to avoid linefeeds inside the varchar2 columns exported into the file.

Then you can reconstruct the linefeeds in the load processes using oReplace(, '0A'xC).

HTH

Cheers.

Carlos.