SQL Assistant Import with embedded carriage returns

Database
Enthusiast

SQL Assistant Import with embedded carriage returns

Hello guys can you suggest a neat way to use the import tool on teradata sql assistant to pull in a txt file that contains carriage returns within the text columns?

I'm getting stung at the moment as I can export the data into a text file fine, but the there is no option for "line terminiator" and so if I get a text block with a carriage return within the exported text file, it won't happily be able to get imported back in.

Otherwise it's back to "fast imports" again.

1 REPLY
Enthusiast

Re: SQL Assistant Import with embedded carriage returns

Hi Rupert,

Try the trim option in fast export or use this command $ cat infile | od -c which would eliminate your carriage returns

Thanx

Sidhhu