topic Re: convert numeric string to numeric string with commas in Application Development and Automation Discussions

convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:23:10 GMT

hi,

how can i convert 1222222.22 to 1,222,222.22 programmatically? both outputs should be in string format.

thanks!

Re: convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:26:24 GMT

hi,

use write statement...

ex.

data: v_value type netpr value '12212332.34'.

DATA: V_STRING(18).

WRITE: V_VALUE TO V_STRING.

WRITE: / V_STRING.

Regards,

naren

Re: convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:28:29 GMT

Hi Winnie,

Not too sure are you doing some conversion of currency, but you can try this FM 'HR_ECM_CONVERT_CURRENCY', like convert from myr to yen

Re: convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:41:45 GMT

hi Chan,

do this way .. it works this way ..

data:ur_var(7) value '1000000'.

data: var(7) type p.

var = ur_var.

write: var.

Regards,

Santosh

Message was edited by: Santosh Kumar P

Re: convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:52:19 GMT

Hi,

U can do like this

DATA: v_waers LIKE essr-waers VALUE 'SGD'.

i_report-netwr = 1222222.22 .

Then
      WRITE i_report-netwr TO v_netwr
          CURRENCY v_waers DECIMALS 2.

This solves ur problem.

Reward points if this answers ur question.

Re: convert numeric string to numeric string with commas

Former Member — Fri, 22 Sep 2006 03:59:56 GMT

good

yes you can do ir

store 1222222.22 in a string

declare one character type with value ,

use a SPLIT statement to split the value 122222.22 and than use CONCATENATE statement to concatenate all the clue with ,(symbol).

thanks

mrutyun^