Adding Thousand/lakh/etc separator in a character variable

[Former Member]

Hi All,

I have a character varialbe which holds value as '12345.67'. Its ok but i want thousand / lakh ..etc separator to appear whenever it is required.

As in this case it should hold '12,345.67'.

So, how can i do this ?

[Former Member]

Hi All,

I have a character varialbe which holds value as '12345.67'. Its ok but i want thousand / lakh ..etc separator to appear whenever it is required.

As in this case it should hold '12,345.67'.

So, how can i do this ?

[former_member226519]

the format how amounts or dates are displayed can be customized for each user in the personnel settings.

In your report you simply WRITE yor typed variables to a CHAR variable and it will appear as defined.

[Clemenss]

Hi John,

first move the character field to a numeric field of type, i.e. WRBTR, then write bach <numfield> to <character field>. If the char field is wide enough, the thousand separators will be added automatically according to user settings format.

Regards,

Clemens

[Former Member]

Use WRITE statement to move the varianle from amount variable to char variable.

Regards,

Nilesh.