Put thousand separator

[Former Member]

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

[Former Member]

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

[Former Member]

CLOI_PUT_SIGN_IN_FRONT.

Use tha above FM

CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'

CHANGING

VALUE = netvalue

[Former Member]

Hi,

Check FM C14N_NUMERIC_FORMAT

Sameena

[Former Member]

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.