Reformatting file using Syncsort
Posted: Thu Dec 18, 2008 3:28 am
Is that possible to get rid of spaces and shift data up? (please see example below)
I also need to sum some fields and get something like:
Thanks!
PRO 00001 00001 AAA
PRO 00001 00001 BBB
PRO 00001 00001 AAA
PRO 00001 00001 AAA
CTR 00001 00001 CCC
CTR 00001 00001 BBB
CTR 00001 00001 BBB
CTR 00001 00001 AAA
PRO 00001 00001 BBB
PRO 00001 00001 AAA
PRO 00001 00001 AAA
CTR 00001 00001 CCC
CTR 00001 00001 BBB
CTR 00001 00001 BBB
CTR 00001 00001 AAA
I also need to sum some fields and get something like:
PRO 00001 00003 AAA CTR 00001 00001 CCC
PRO 00001 00001 BBB CTR 00002 00002 BBB
CTR 00001 00001 AAA
PRO 00001 00001 BBB CTR 00002 00002 BBB
CTR 00001 00001 AAA
Thanks!