Sum an alphanumeric fields
Posted: Thu Jul 03, 2014 2:10 am
Hi everybody, I have this problem: I have to sum alphanumeric fields using JCL but I can not find the solution.
Input file
Output file
Can you help me?
Thanks.
Input file
KEY VALUE
----+----1----+----1----+----1----+----1
0000000100 +0000000500,34
0000000100 +0000023344,00
0000000200 +0000002200,99
0000000200 -0000001500,99
0000000300 -0000000100,00
----+----1----+----1----+----1----+----1
0000000100 +0000000500,34
0000000100 +0000023344,00
0000000200 +0000002200,99
0000000200 -0000001500,99
0000000300 -0000000100,00
Output file
KEY VALUE
----+----1----+----1----+----1----+----1
0000000100 +0000023844,34
0000000200 +0000000700,00
0000000300 -0000000100,00
----+----1----+----1----+----1----+----1
0000000100 +0000023844,34
0000000200 +0000000700,00
0000000300 -0000000100,00
Can you help me?
Thanks.