Strip off ^M

[proggybilly]

I am working with reading a dos file and putting the information into a database. The file however has ^M after each line and this causes the entry in the database to not match up when relating it to other tables. I need an easy way to strip off the ^M. Chomp is not doing it and when I try to use dos2unix, I get an error using it.

 

[feherke]

Hi

when I try to use dos2unix, I get an error using it.

Then why not post the error message in forum822 or forum80 so we can help to correct it ?

Anyway, with [tt]perl[/tt] you can also remove the carriage-return characters :

perl -i -pe 's/\r$//' /path/to/file

Feherke.

http://rootshell.be/~feherke/

 

[readey]

Use chop, then chomp - that does the trick

 

[feherke]

Hi

Use chop, then chomp

Actually first [tt]chomp[/tt] then [tt]chop[/tt]. And then put back the [tt]\n[/tt]. And of course, use it only if all lines have [tt]\r[/tt] too. :-(


Feherke.

http://free.rootshell.be/~feherke/