topic Re: Delete control M character using tr command. in Operating System - HP-UX

Delete control M character using tr command.

uform — Mon, 25 Sep 2006 10:02:03 GMT

1) How to do it ? following is not working for me ..

tr -d '\r' test.dat > test1.dat

2) How to get only the records which has control M in it ?

Re: Delete control M character using tr command.

Pete Randall — Mon, 25 Sep 2006 10:06:29 GMT

The simpler way would be to use the dos2ux command.

Pete

Re: Delete control M character using tr command.

IT_2007 — Mon, 25 Sep 2006 10:06:31 GMT

you edit file with vi and do the following after pressing "Esc" key.

:%s/

//g

it will remove all ^M character in that file.

Re: Delete control M character using tr command.

Peter Godron — Mon, 25 Sep 2006 10:08:42 GMT

Hi,
how about:
tr -d "\015" < test.dat > test1.dat

Don't forget, to get the ^M in UNIX command you have to use CTRL+V CTRL+M.

Re: Delete control M character using tr command.

James R. Ferguson — Mon, 25 Sep 2006 10:31:47 GMT

Hi:

Yet another way is:

# perl -pe 's/\r\n/\n/;s/\032//' file

This handles not only carriage-return characters (^M) but also any end-of-file character (^Z).

Regards!

...JRF...

Re: Delete control M character using tr command.

Ralph Grothe — Mon, 25 Sep 2006 11:19:27 GMT

You simply need to redirect your stdin from the file with the superfluous CRs as Peter showed you.
Unlike its bigger brother sed the tr command requires this.

Re: Delete control M character using tr command.

uform — Mon, 25 Sep 2006 12:01:54 GMT

Thanks all...

i just left '<' before test.dat
tr -d '\r' test.dat > test1.dat

tr -d '\r' < test.dat > test1.dat
this worked for me...

Thanks again.

Re: Delete control M character using tr command.

Geoff Wild — Mon, 25 Sep 2006 12:19:39 GMT

You can also use the col command:

cat test.dat |col -b > test.dat.1

or

col -bx test.dat test.dat.1

Rgds...Geoff

Re: Delete control M character using tr command.

Bill Hassell — Mon, 25 Sep 2006 18:21:37 GMT

Actually, you just need to transfer the files correctly. CTRL-M is a PC artifact. Or more accurately, you are transferring a file from a very different computer without proper translation. If you used FTP, you need to set the ASCII translator for these files. Note that BINARY does no translation so you get the file as it appears inside the PC -- which is not compatible with Unix (Unix uses LF for end-of-line, PCs use CR+LF, other systems use other characters). Every line has CTRL-M at the end but FTP knows how to convert between different systems.

Now if you are sharing directories between dissimilar systems, the same rule holds true. The PC files appear exactly as they exist on each system. A Unix file will have black squares at the end-of-line when viewed in Notepad, and a PC file will have CTRL-M's when viewed in Unix.

What to do? Well, there's no way to get t5he two different OS's to change so you'll have to translate whichever way you need. The 2 commands are:

dos2ux
and
ux2dos

(there's no similar commands on a PC).

Re: Delete control M character using tr command.

James R. Ferguson — Mon, 25 Sep 2006 19:13:38 GMT

Hi:

To add to Bill's comments, while 'dos2ux' and 'ux2dos' are UNIX commands, Perl runs on virtually any platform. Hence on a UNIX or on a Microsoft Windows server the following are true:

In lieu of 'dos2ux' use:

# perl -pe 's!\r\n!\n!;s!\032!! if eof' file

...and in lieu of 'ux2dos' use:

# perl -pe 's!\n!\r\n!s;END{print "\032"}' file

Regards!

...JRF...