Shell Programming and Scripting

You could also just have awk ignore the extra char on the end like this:

Code:

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

Thanks Corona688 for your input !
Here is another solution using AWK:

Code:

~/unix.com$ awk '{gsub("\r","");print > "file"$NF".txt"}' RAW

Thank you all for your replies. i will try them and let you know. thanks again

---------- Post updated at 11:58 AM ---------- Previous update was at 10:09 AM ----------

i got it without the space in the file name but since the "\r" is removed (carriage return) my rows all are jumbled up. when i view in Notepad++ i see only [LF] at end of line and it is not like [CR][LF] at end of line. this cause multiple rows in one line. i was going to use the file to import into SQL server but that would cause an error without a correct line breaker like [CR][LF].

is there way to append to the code to have the carriage return?

---------- Post updated at 12:18 PM ---------- Previous update was at 11:58 AM ----------

Note: I used Chuber's code and renamed the file extensions. it does involve time but i got what i need now. thanks


Code:

Code:

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