FastLoad vs NL Character

Tools
Fan

FastLoad vs NL Character

I have a text file with records I want to import into Teradata with FastLoad.
Columns are separated with a "|" character.
There is a problem with a 'Comments' column containing rows with a new line character.
For FastLoad new line is a new record so it gives an error of insufficient number of columns.
Any ideas how I can deal woth new line characters without changing the text file?

Thanks,
Marek
1 REPLY
hh
Enthusiast

Re: FastLoad vs NL Character

maybe define that newline character but not loading it? Hope that helps..