Shell Programming and Scripting

uname -a gives...

AIX carnowen 2 5 005AA72F4C00

I need to remove a combination of ^M and newline character.

i tried...

sed s/^M\n//g but this does not work :'(

thanks for your help mate.

When you say new line character, I assume you want two lines into 1 single line, or likewise.

Try this.

Code:

sed -e 's/^M\\n//g' file

If it doesnt work, show us a sample input and how you expect the output to be.

text file is like follows (this is how it would look using vi)

line1field1 line1field2 line1field3 line1field4 line1field5
line2field1 line2field2 line2field3 line2field4 line2field5
line3field1 line3field2 line3field3^M
line3field4 line3field5
line4field1 line4field2 line4field3 line4field4 line4field5
line5field1 line5field2 line5field3 line5field4 line5field5

I need this to become


line1field1 line1field2 line1field3 line1field4 line1field5
line2field1 line2field2 line2field3 line2field4 line2field5
line3field1 line3field2 line3field3 line3field4 line3field5
line4field1 line4field2 line4field3 line4field4 line4field5
line5field1 line5field2 line5field3 line5field4 line5field5

I tried the sed command you used in your previous post but this hasn't worked. Again, thanks for your help friend.

maybe there's a different way of representing newline characters when using sed??

if i use

sed -e s/^M//g myFile.out

then the ^M is removed. All i need to do now is try and get line 3 in the above example onto one line!!

Anyone got any ideas?? This is doin' my 'ead in!!!

Got perl?

perl -00pe 's/\r\n//g' myFile.out

unfortunately i can't use perl mate. it's not available. it has to be done using a regular expression in UNIX.

I am returning results set from Sybase stored proc. Is there a function in Sybase that may remove the newline characters?