khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi all,
I was trying to extract the value from i/p which contains some - signs with values. With my Inrec condition i am not getting the exact o/p which i need. Please find the below i/p & o/p details and instruct me.
Code: |
I/P file values:
767072.000
198000.000
1792270.000
-50000.000
65000.000
CopyBook layout:
--------- FIELD LEVEL/NAME ---------- -PICTURE- -NUMBER START END LENGTH
5 GL-ORIG-FACE S9(11)V999 15 81 88 8
|
O/P file is coming as
0000767072.000
0000198000.000
0001792270.000
0000050000.000
0000065000.000
Inrec filed is:
Code: |
110:81,8,PD,EDIT=(TTTTTTTTTT.TTT),SIGNS=(,-), |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
khamarutheen,
Code: |
110:81,8,PD,EDIT=(TTTTTTTTTT.TTT),SIGNS=(,-),
|
Your SIGNS=(,-) gives a leading sign that corresponds to an S in the EDIT mask. Since you don't have an S in the edit mask, you don't get a sign. If you want a leading sign, you need an S for it:
Code: |
110:81,8,PD,EDIT=(STTTTTTTTTT.TTT),SIGNS=(,-),
|
|
|