UNIX for Advanced & Expert Users

It was a bug, so IBM fixed it! Maybe you reported it! It was useful -- we cannot have that!

Hi,

I did not loop the awk script but found an easier solution like the one given below.
Right now it is working well on my AIX server.
But when i migrate the same to my LINUX server, its not executing.

Can anyone help..

Code:

pk1=1,3,2,4
mc1=6,5
pkcols1=`echo $pk1 | sed 's/,/,$/g'`
cols1=`echo $mc1 | sed 's/,/,$/g'`
awk -F, '{print'`echo "$"$pkcols1",$"$cols1`'}' OFS=, file1.txt

Try nawk?

I used the command dos2unix while moving the file from my windows to linux server and it worked perfectly

But i do want to know what exactly does this command do.. because when i transfer my file from windows to my AIX box, my code works fine even without converting.

Is this something specific to LINUX?

---------- Post updated at 09:25 PM ---------- Previous update was at 01:57 PM ----------

I am stuck up with yet another change to this code..

While the following code helps me to cut the columns in the required layout and create a new file, the file generated is comma separated. Is there a way where i can define which delimiter my output file should contain?

Code:

pk1=1,3,2,4
mc1=6,5
pkcols1=`echo $pk1 | sed 's/,/,$/g'`
cols1=`echo $mc1 | sed 's/,/,$/g'`
awk -F, '{print'`echo "$"$pkcols1",$"$cols1`'}' OFS=, file1.txt

I cannot use a sed and replace the comma with the delimiter i need, because my input file might contain comma in the data.

What usually matters is how you transfer the file. For example "ftp" in text mode will do the conversion for you. This is not specific to AIX or Linux.

I recall it is mostly add/remove carriage returns before line feeds for dos and not for UNIX (but life also includes cr in place of lf for Apple, and then there is EBCDIC, unicode, UTF-8, . . . . ).

@DGPickett

The line terminator for text files in unix is one character: linefeed.

The line terminator for text files in MSDOS is two characters: carriage-return, linefeed.