Shell Programming and Scripting

I'f you know you only have a few different record types you could try something like this:

Code:

awk '{ print > "file." substr($0,length-1) }' RAW

otherwise try

Code:

awk '
/T0$/ { print > "file1" ; next }
/P1$/ { print > "file2" ; next }
/P2$/ { print > "file3" ; next }
/P3$/ { print > "file4" ; next }
{ print > "file.UNKNOWN" }' RAW

Thank you. i did the first method and changed a little

awk '{print > "file.txt" susbtr($0,length-2) }' RAW

i did length -2 to get the TO, P1 etc appended to output files and also added ..txt hoping i would get fileT0.txt, fileP1.txt but i get file.txtT0, file.txtP1.

is there a way to have it saved as .txt extension when it outputs?

Thanks

Code:

awk '{print > "file"$NF".txt"}' RAW

Works perfect. thanks again

---------- Post updated at 04:54 PM ---------- Previous update was at 04:43 PM ----------

sorry to bother again but when i use ls command to list it the file is displayed as fileT0?.txt. it opens in my ubuntu machine but when i try to copy it into windows box, it doesn't open because the file is displayed as fileT0 .txt.(there is a space). i am not able to rename it nor copy it.

any help?

I suspect your RAW file to have \r\n at the end of each line (typically all txt files created from MS Windows notepad). You have to remove \r from the original file. Try (not tested)

Code:

tr '\r\n' '\n' RAW > RAW.1

and retry the awk script with RAW1

The file was received from a client and they said it was from z/OS system. i tried the code but it says 'tr - extra operand' and the output file is 0 byte

---------- Post updated at 05:21 PM ---------- Previous update was at 05:15 PM ----------

i opened the raw file in notepad++ and has the [CR][LF] at the end of each line

like

..........................T0[CR][LF]
..........................P1[CR][LF]
..........................P2[CR][LF]
..........................P2[CR][LF]
..........................P2[CR][LF]

tr does not work that way. It deals with individual characters, not strings. Since you gave it two characters on the input, it's expecting 2 characters on the output, too.

This should work:

Code:

tr -d '\r' < input > output