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

Adding comma as thousand separator

Former Member
0 Likes
8,882

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

9 REPLIES 9
Read only

Peter_Inotai
Active Contributor
0 Likes
2,517

Statement WRITE field1 TO field2 will add this formating.

Peter

Read only

0 Likes
2,517

hi Nishanth,

do this way.

data: f1 type i,

f2 type i.

Write f1 to f3.

Regards,

Santosh

Read only

0 Likes
2,517

And what is the type of field2???

Read only

abdul_hakim
Active Contributor
0 Likes
2,517

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

Cheers,

Abdul Hakim

Mark all useful answers..

Read only

Former Member
2,517

Hi

Use write statament:

DATA: AMOUNT TYPE WRBTR VALUE '33329.00',

AMOUNT_C(20) TYPE C.

WRITE AMOUNT CURRENCY 'EUR' TO AMOUNT_C.

Max

Read only

Former Member
0 Likes
2,517

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

Read only

Former Member
0 Likes
2,517

Nishant,

Look at the EDIT MASK option of the WRITE statement.

Regards,

Ravi

Read only

0 Likes
2,517

Hi Nishanth,

Check my post....

Read only

Former Member
0 Likes
2,517

Hi

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