Re: replacing CR/LF

Hi Marcus,

Yes there is a simple way to fix this.

Many times I've had to export text from windows text files.
Here's how I do it.

After moving the text files onto Linux use this command to
clear up the offending character(s)

cat file.txt | perl -pe 's:\r::g' > file2.txt

Inside file2.txt all the \r have been replaced with nothing.

Lets say now you then need to clean up some pesky $ as well.

Just press the up arrow on your keyboard to bring up the command's
you just executed and edit them a little to look like this:

cat file2.txt | perl -pe 's:\$::g' > file3.txt

As you can see these commands can be handy to clean up all sort's
of characters.

Hope this helps.

Cheers
Rudi.





> Hello, all.
>
> I have some data imported from some windows text files with a couple
> DOS end-of-line characters (CRLF) on it.
>
> Is there any simple way to remove them all, or just replace them
> with a single whitespace character??
>
> thanks.
>
> -------------------------------
>    http://www.vlinfo.com.br
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org