madishpa
New User
Joined: 18 May 2007
Posts: 28
Location: Hyderabad
|
|
|
|
Hi,
My input looks like below in 132 position in a flat file.
-0000000114612
0000000114612
-0000000111103
I need to get an out put as below:
-$1,146.12
$1,111.03
-$1,146.12
I tried using the following code:
| Code: |
| 132,14,ZD,EDIT=(S$III,III,III,IIT.TT),LENGTH=15,SIGNS=(-,+) |
I got out put as below.
-$1,146.12
-$1,111.03
-$1,146.12
I changed the sign key word as SIGNS=(+,-)
| Code: |
| 132,14,ZD,EDIT=(S$III,III,III,IIT.TT),LENGTH=15,SIGNS=(+,-) |
it gave a result as
+$1,146.12
+$1,111.03
+$1,146.12
Could any body help me out with my issue.
Thanks in advance. |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Your input is NOT ZD format and you have the SIGNS wrong. You need to use SFF (signed free form) format instead and the correct SIGNS values like this:
132,14,SFF,EDIT=(S$III,III,III,IIT.TT),LENGTH=15,SIGNS=(,-)
The output will be:
| Code: |
-$1,146.12
$1,146.12
-$1,111.03
|
For more details on DFSORT formats, see:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA30/C.0?DT=20080528171007 |
|
