Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

converting currency fields into strings without separators

Former Member
0 Likes
716

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
651

Hi,

Use the NO-GROUPING addition with the WRITE statement.

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

Manoj

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

3 REPLIES 3
Read only

Former Member
0 Likes
652

Hi,

Use the NO-GROUPING addition with the WRITE statement.

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

Manoj

Read only

0 Likes
651

Ahhhh thanks!

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

Message was edited by: Bee Huat, Leonard Yong

Read only

Former Member
0 Likes
651

hi all

then what is the fm used for indian currency

thx