Re: [GENERAL] Data loading from a flat file...

[Bricklen Anderson]

Pandurangan R S wrote:
To get rid of ^M characters you could use
cat file | tr -d ^M

you need to type ^V before you type ^M in the preceeding command. But
^V will not be displayed on the screen.

Or you can use dos2unix/unix2dos, if installed. I believe they are in 
the sysutils package.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend