|
View previous topic :: View next topic
|
| Author |
Message |
baljinders
New User
Joined: 21 Aug 2006
Posts: 72
|
|
|
|
Hi,
I am ftping a flat file to excel sheet. The issue here is that one of the fields for the flat file has picture clause of S9(15)V99. This field contian amounts.
The value is excel sheet is appearing like 0000000002217691{ for a value of 221769.10
This means i need to convert S9(15)V99 to a displayable format. Can anyone tell me what should be the desired picture clause that i should convert this field to. |
|
| Back to top |
|
 |
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
|
|
|
|
Drop the "S" and all will be forgiven.... 
Bill |
|
| Back to top |
|
|
arvind.m
Active User
Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad
|
|
|
|
| Quote: |
This means i need to convert S9(15)V99 to a displayable format.
|
If i understood correctly it means edited format...
9(15).99 |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
Source field is signed, so need one of these (or with - instead of + for no sign if pos; or with some Z's for zero suppression):
+9(15).99 or 9(15).99+ |
|
| Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006
Posts: 72
|
|
|
|
Thanks guys,
I used -ZZZZZZZZZZZZ9.99 and got the desired result. |
|
| Back to top |
|
|
|
|
