sarat6900
New User
Joined: 02 Mar 2009 Posts: 12 Location: India
|
|
|
|
Hi All,
The fields in my input file are comma separated but can have varying length.
For Eg.
Rec1 : AH,TEST 2222,JHHsss,03/21/2010,9,c
Rec2 : AAA,TESssT aa2222,JHHsss,03/21/2010,5,c
Rec3 : AAA,TESssT ddd2222,JHHsss,03/21/2010,18,c
Rec4 : AAA,TEssST sddd2222,JHHsss,03/21/2010,1,c
Rec5 : AAA,TEssST a2222,JHHsss,03/21/2010,2,c
Rec6 : B11,TEsST ddd2222,JHHsss,03/21/2010,13,c
Rec7 : B11,TEsST ssssss2222,JHHsss,03/21/2010,1,c
Rec8 : B11,TEsST ddsssd2sssssss222,JHHsss,03/21/2010,3,c
I would like to have the input file sorted on field 1(AH on first Rec) and then by the second last field (9 on first Rec)
expected output
Rec1 : AH,TEST 2222,JHHsss,03/21/2010,9,c
Rec4 : AAA,TEssST sddd2222,JHHsss,03/21/2010,1,c
Rec5 : AAA,TEssST a2222,JHHsss,03/21/2010,2,c
Rec2 : AAA,TESssT aa2222,JHHsss,03/21/2010,5,c
Rec3 : AAA,TESssT ddd2222,JHHsss,03/21/2010,18,c
Rec7 : B11,TEsST ssssss2222,JHHsss,03/21/2010,1,c
Rec8 : B11,TEsST ddsssd2sssssss222,JHHsss,03/21/2010,3,c
Rec6 : B11,TEsST ddd2222,JHHsss,03/21/2010,13,c
Can i unstring and sort the file?
Any help is highly appreciated.
Thanks,
Sarat. |
|