topic Convert String to Currency in Application Development and Automation Discussions

Convert String to Currency

Former Member — Thu, 01 Nov 2007 08:14:20 GMT

Hi Experts,

I read from text file to an internal table.

My text file contains data (eg. 1,799.01).

When i try to store into internal table, i couldn't do so cos the string cant store the value as currency (internal table field is currency).

How do i do so?

I tried removing ',' and the condense the string no gaps such that data becomes 1799.01 but still the internal table does not accept the string (as i'm forcing it to store into a currency).

Please help!

Re: Convert String to Currency

Former Member — Thu, 01 Nov 2007 08:16:52 GMT

no need to store , in internal table but while output just make change in field catelog with datatype = 'CURR' .

Re: Convert String to Currency

Former Member — Thu, 01 Nov 2007 08:33:54 GMT

Have u tried using Currency format with Write Statement ..

Write field( from file) TO varaible(defined by you) Currency CURR(like JPY etc) .

This will wite string as per the currency format given by you .

Hope this may help.

Praveen

Re: Convert String to Currency

former_member386202 — Thu, 01 Nov 2007 08:41:09 GMT

Hi,

Change the datatype of internal table field as character type.

Regards,

Prashant