topic Re: Put thousand separator in Application Development and Automation Discussions

Put thousand separator

Former Member — Tue, 20 Jun 2006 09:40:43 GMT

Hi,

I'd like to add the thousand separator in a string of characters that represents a number. The number can be both positive or negative, and when it is negative I want to keep the negative sign at the front when I write it on a report. E.g.:

'1567,34' --> '1.567,34'

'-1567,34' --> '-1.567,34'

I'd like to know if there's any FM or a quick way to do it.

Thanks in advance,

Gerard

Re: Put thousand separator

Former Member — Tue, 20 Jun 2006 09:42:54 GMT

Hi,

Use the EDIT MASK option in the WRITE statement for the format.

FOr the -ve sign use the function CLOI_PUT_SIGN_IN_FRONT

Regards,

Ravi

Note : Please mark the helpful answers

Re: Put thousand separator

Former Member — Tue, 20 Jun 2006 09:46:14 GMT

CLOI_PUT_SIGN_IN_FRONT.

Use tha above FM

CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'

CHANGING

VALUE = netvalue

Re: Put thousand separator

Former Member — Tue, 20 Jun 2006 09:50:56 GMT

Hi,

Check FM C14N_NUMERIC_FORMAT

Sameena

Re: Put thousand separator

Former Member — Tue, 20 Jun 2006 10:06:55 GMT

Hi Sameena,

Do you know how to use this the FM C14N_NUMERIC_FORMAT? I don't the format in which I have to import the parameters.

Thanks in advance.