DSXchange

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

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

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

Thank you Ahmed