Summing positive and negative values
Posted: Thu Sep 04, 2008 12:45 pm
I am looking for a solution for the below sample data,
1000000000023 T062 0001 00000-4500
1000000000023 T062 0002 0000000000
1000000000023 T062 0002 0000009000
1000000054012 T025 0003 00000-3500
1000000054012 T025 0002 0000000-20
1000000054012 T025 0001 000000-900
For the above, o/p should be as below
1000000000023 T062 0005 0000004500
1000000054012 T025 0006 00000-4620
- Prachi
1000000000023 T062 0001 00000-4500
1000000000023 T062 0002 0000000000
1000000000023 T062 0002 0000009000
1000000054012 T025 0003 00000-3500
1000000054012 T025 0002 0000000-20
1000000054012 T025 0001 000000-900
For the above, o/p should be as below
1000000000023 T062 0005 0000004500
1000000054012 T025 0006 00000-4620
- Prachi