topic Re: converting currency fields into strings without separators in Application Development and Automation Discussions

converting currency fields into strings without separators

Former Member — Fri, 13 Oct 2006 04:33:33 GMT

Hi all,

Currently i'm using the write statement to do the conversions.

data : amt(30).

write bseg-dmbtr into amt currency 'USD'.

However the output is in "123,456.00" format.

I need the output in "123456.00" without the commas.

Other than doing a "REPLACE" command for the commas in the amt string, is there a better way of getting the desired currency output without commas?

regards

Former Member — Fri, 13 Oct 2006 04:51:05 GMT

Hi,

Use the NO-GROUPING addition with the WRITE statement.

write bseg-dmbtr into amt <b>NO-GROUPING</b> currency 'USD'.

Manoj

Former Member — Fri, 13 Oct 2006 05:05:10 GMT

hi all

then what is the fm used for indian currency

thx

Former Member — Fri, 13 Oct 2006 06:39:16 GMT

Ahhhh thanks!

I get error while rewarding the solution? I'll try again later

Message was edited by: Bee Huat, Leonard Yong