Datastage Gurus,
I am getting fixed width file file from one of our users,in some fields in the last positions i am seeing EBCDIC characters,but i need to convert like the below examples:
a. Billing amount value = 000000200{
Ans:the billing amount is +20.00 dollars.
b. Billing amount value = 000004523C
Ans: the billing amount is +452.33 dollars.
c. Billing amount value = 000023981P
Ans:the billing amount is -2398.17 dollars.
Can you please light on me.
Thanks in advance.
Reddy
EBCDIC CONVERSION
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 13
- Joined: Tue Apr 08, 2003 9:51 pm
- Location: Australia
Reddy
Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.
eg.
DataTypePicS9(000000200{)/100 = 20.00
Thanks
Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.
eg.
DataTypePicS9(000000200{)/100 = 20.00
Thanks
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Hi Guys,rasi wrote:Reddy
Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.
eg.
DataTypePicS9(000000200{)/100 = 20.00
Thanks
Thanks a lot for a quick responses.
I need to get the output with + and _ Signs like this
+20.00 dollars
Thanks in advance
reddy
Reddy - what is not working the way you would like by using the DataTypePicS9 conversion?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>