UNIX for Dummies Questions & Answers

Try nawk instead of awk

HI Anubu

I have used nawk , its working OK , still there is an issue . please have look at the output file .

The actual output file generated by script :

05Payables|5000000034|10|1|414100205255|1
05Payables|5000000034|11|1|414100205143|10
05Payables|5000000034|12|1|414100205143|11
05Payables|5000000034|13|1|414100205143|12
05Payables|5000000034|14|1|414100205143|13
05Payables|5000000034|1|1|414100205143|1


Expected file :

05Payables|5000000034|1|1|414100205143|1
05Payables|5000000034|10|1|414100205255|1
05Payables|5000000034|11|1|414100205143|10
05Payables|5000000034|12|1|414100205143|11
05Payables|5000000034|13|1|414100205143|12
05Payables|5000000034|14|1|414100205143|13

Pls suggest me how to come over this

Thanks
hari

Code:

$ sort -k2,2 -kn3 -k1,1 -t'|' file
05Payables|5000000034|1|1|414100205143|1
05Payables|5000000034|10|1|414100205255|1
05Payables|5000000034|11|1|414100205143|10
05Payables|5000000034|12|1|414100205143|11
05Payables|5000000034|13|1|414100205143|12
05Payables|5000000034|14|1|414100205143|13

In the following examples, first the preferred and then the obsolete way of specifying sort keys are given as an aid to understanding the relationship between the two forms.

Example 1 Sorting with the second field as a sort key
Either of the following commands sorts the contents of infile with the second field as the sort key:

example% sort -k 2,2 infile
example% sort +1 -2 infile

Hi Anubu

I tried to execute the code which you have , I am getting foolowing message

sort -k2,2 -kn3 -k1,1 -t'|' file ( I have tried with $ and without $ )

usage: sort [-cmu] [-o output] [-T directory] [-S mem] [-z recsz]
[-dfiMnr] [-b] [-t char] [-k keydef] [+pos1 [-pos2]] files...

and it was not showing any data.

Thanks
Hari