|
View previous topic :: View next topic
|
| Author |
Message |
Michaelod
Warnings : 1
New User
Joined: 02 Sep 2008
Posts: 49
Location: Edinburgh
|
|
|
|
I have an S9(13)v9(2) comp-3 field in an input record that I wish to map to an S9(14)v9(2) field in an ouptut record.
I have tried the following to no avail:
158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(+,-),LENGTH=16,
Anyone have any ideas?
Thanks |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Michaelod,
Would u Please provide us sample i/p & o/p ? |
|
| Back to top |
|
|
Michaelod
Warnings : 1
New User
Joined: 02 Sep 2008
Posts: 49
Location: Edinburgh
|
|
|
|
| guptae wrote: |
Hello Michaelod,
Would u Please provide us sample i/p & o/p ? |
Hi,
| Quote: |
From position 179 in the Input record the data is as follows (hex):
00000350
0000010D
When I execute the following step:
158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(+,-),LENGTH=16
I get the following in the output file:
From position 158
000000000031500 |
For some reason there is no sign. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| For some reason there is no sign. |
The reason is that you specified a trailing sign in the EDIT pattern, but you didn't specify trailing signs in SIGNS. You can use this:
158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(,,+,-),
The syntax for SIGNS is (lp,ln,tp,tn) where:
lp=leading positive sign
ln=leading negative sign
tp=trailing positive sign
tn=trailing negative sign
SIGNS=(+,-) gives the leading signs, not the trailing signs.
SIGNS=(,,+,-) gives the trailing signs.
Note that you don't need LENGTH=16 since the length is taken from the EDIT pattern by default. |
|
| Back to top |
|
|
|
|
|
