Arithmetic operator: exponentiation (** or ^)
Posted: Tue Feb 14, 2012 3:25 am
Hello,
I have an input file with numeric fields like this:
The first 6 digits are prices, and the following 2 digits are the number of decimals. So previous records are interpreted as: 9.83, 1.075, 560, and 34.5
I'd like the output to be something like the following:
I wonder whether DFSORT has an exponentiation arithmetic operator like Cobol's **, or Visual Basic's ^, or a funxtion like SQL's power().
Thanks,
Regards.
I have an input file with numeric fields like this:
00098302
00107503
00056000
00034501
00107503
00056000
00034501
The first 6 digits are prices, and the following 2 digits are the number of decimals. So previous records are interpreted as: 9.83, 1.075, 560, and 34.5
I'd like the output to be something like the following:
0009.83
001.075
0000560
00034.5
001.075
0000560
00034.5
I wonder whether DFSORT has an exponentiation arithmetic operator like Cobol's **, or Visual Basic's ^, or a funxtion like SQL's power().
Thanks,
Regards.