Sorting data using 'Filter' command

yaminids · Post by **yaminids** » Wed May 04, 2005 12:57 pm

Hello friends,

I am trying to sort data using 'Filter' command for the first time. The input sequential file has 40 columns and I am trying to sort the file on 21st, 22nd and 23rd columns.

Can anyone explain to me how to specify the sort statement in 'Filter' segment in the Sequential file stage.

Thanks a lot in advance
-Yamini

chulett · Post by **chulett** » Wed May 04, 2005 1:03 pm

Did you try searching first before asking? A quick check shows 27 hits in this forum using sort and filter as keywords.

ahmediftikhar · Post by **ahmediftikhar** » Thu May 05, 2005 2:50 am

Hello Yamini

Try this out in the filter command:

sort -t "," -k 21,23 <Filename>

where "," is the delimeter and 21,23 is the column number from 21st to 23rd to be sorted.

Hope this helps

Ahmed

yaminids · Post by **yaminids** » Thu May 05, 2005 11:59 am

Thank you Ahmed