topic Re: Adding comma as thousand separator in Application Development and Automation Discussions

Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:39:11 GMT

Hi ,

I have a amount field having value "33329.00"

I need to convert it to "33,229.00".

How do i proceed?

Regards

Nishant

Re: Adding comma as thousand separator

Peter_Inotai — Fri, 02 Jun 2006 14:40:42 GMT

Statement WRITE field1 TO field2 will add this formating.

Peter

Re: Adding comma as thousand separator

abdul_hakim — Fri, 02 Jun 2006 14:41:53 GMT

assign this value to any type I or type P variables.

Cheers,

Abdul Hakim

Mark all useful answers..

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:41:54 GMT

hi Nishanth,

do this way.

data: f1 type i,

f2 type i.

Write f1 to f3.

Regards,

Santosh

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:42:12 GMT

And what is the type of field2???

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:42:19 GMT

Use write statament:

DATA: AMOUNT TYPE WRBTR VALUE '33329.00',

AMOUNT_C(20) TYPE C.

WRITE AMOUNT CURRENCY 'EUR' TO AMOUNT_C.

Max

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:42:21 GMT

MOve it to a field of type <b>wrbtr</b>.

It would be automatically converted to the format you want.

data: v_amt_new type wrtbr.

move v_amt to v_amt_new.

write v_amt_new.

Regards,

Ravi

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:42:28 GMT

Nishant,

Look at the EDIT MASK option of the WRITE statement.

Regards,

Ravi

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:43:52 GMT

Hi Nishanth,

Check my post....

Re: Adding comma as thousand separator

Former Member — Fri, 02 Jun 2006 14:43:59 GMT

set the thousand seperator in system -> userprofile -> owndata -> deafults