UNIX for Dummies Questions & Answers

Hi All

I have a file and having 6 columns in that one . I need to sort the file based 2nd , 3rd and 1st column . Can anybody suggest me how to do this .I am new to UNIX.

Output file name : /data/Projects/Payable.txt

Record_Id | Ord_number | Line_No | External_Contact|
05Paybles |1111| 10 | NA
05Paybles |1000| 1 | NA
05Paybles |1111| 2 | NA
05Paybles |1000| 2 | NA




Thanks in advance

Hari

See if this works for you:

Code:

sort -k2,2 -k3,3 -k1,1 -n -t'|' input_file

Code:

sort -k 2,2n -k 3,3n -k 1,1n /data/Projects/Payable.txt

Hi All
Thanks a lot for the reponses .

The Output file :

Record_Id | Ord_number | Line_No | External_Contact|
05Paybles |1111| 1 | NA
05Paybles |1111| 10 | NA
05Paybles |1111| 2 | NA
05Paybles |2222| 2 | NA
05Paybles |1111| 11 | NA
05Paybles |1111| 12 | NA
05Paybles |1111| 22 | NA
05Paybles |1111| 21 | NA
05Paybles |1111| 25 | NA
05Paybles |1111| 3 | NA
05Paybles |1111| 33 | NA



After sorting My output should be like this :

05Paybles |1111| 1 | NA
05Paybles |1111| 10 | NA
05Paybles |1111| 11 | NA
05Paybles |1111| 12 | NA

05Paybles |1111| 2 | NA
05Paybles |1111| 21 | NA
05Paybles |1111| 22 | NA

05Paybles |1111| 3 | NA
05Paybles |1111| 33 | NA

05Paybles |2222| 2 | NA


I have tried like this

sort -k2,2 -k 3.1,3.2 -k1,1 -n -t'|' /data/Projects/Payable.txt > /data/Projects/PayableI.txt`date "+%Y%m%d%H%M%S"`.txt

The output is not as expected.

Pls suggest me how to implement this logic.

Thanks in advance

hari

Try, ( Sorting based on 2nd,3rd and first fields)

Code:

 sort -t'|' -k2n -k3n -k1d /tmp/file

Also Try ( To get the answer in the previous post)

Code:

sort -t'|' -k2n /tmp/file

Thanks
Nagarajan Ganesan

Code:

$ sort -k2,2 -k 3.1,3.2 -k1,1 -t'|'  file |
> awk -F"|" '
> NR == 1 { first_char=substr(int($3),1,1) }
> $3 !~ "^ *"first_char { first_char=substr(int($3),1,1); $0="\n"$0 }
> 1 '
05Paybles |1111| 1 | NA
05Paybles |1111| 10 | NA
05Paybles |1111| 11 | NA
05Paybles |1111| 12 | NA

05Paybles |1111| 2 | NA
05Paybles |1111| 21 | NA
05Paybles |1111| 22 | NA
05Paybles |1111| 25 | NA

05Paybles |1111| 3 | NA
05Paybles |1111| 33 | NA

05Paybles |2222| 2 | NA

Iam tring to execute the below script but iam getting error

cd /data/Projects
sort -k2,2 -k 3.1,3.2 -k1,1 -t'|' Payable.txt |
awk -F"|" '
NR == 1 { first_char=substr(int($3),1,1) }
$3 !~ "^ *"first_char { first_char=substr(int($3),1,1); $0="\n"$0 }
1 '

Error
awk: syntax error near line 3
awk: bailing out near line3

Please help