sort and sum a column using syncsort

mrkerala · New User Joined: 25 Jul 2006 Posts: 2

Help help help

I'm trying to sort and sum the column of the following file using syncsort

123456789a123s123000025
123456789a123s124000025
123456799a133s125000025
123456789a133s126000010

for the above file i want to sort first 9 char asc then sort col 10:4 asc and remove duplicate and sum the last 4 char to the lowest of col 10:4 value if the first 9 char are the same but col 10:4 is different

expected ouput of the above file

123456789a123s123000035
123456799a133s125000025

Thanks for you help in advance

sril.krishy · Posted: Tue Jul 25, 2006 2:52 pm

Hi,

It seems that your requirement is not correct.Could you answers the below.

1)on what basis you want to remove the duplicates(on 1:9 or 10:4)
2)what do you mean by lowest of 10:4,the 10:4 value will A123 ?

Thank you
Krishy

mrkerala · New User Joined: 25 Jul 2006 Posts: 2

Krishy thanks for the quick response

1)on what basis you want to remove the duplicates(on 1:9 or 10:4)
Based on 1:9

2)what do you mean by lowest of 10:4,the 10:4 value will A123 ?
A123 within 1:9