topic Re: separate commas from amount in Application Development and Automation Discussions

separate commas from amount

Former Member — Tue, 02 Jun 2009 04:17:23 GMT

Hi there,

How to separate commas from amount?

Example:

12,000,000.00 to 12000000.00

Thank You.

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 04:22:44 GMT

Hi Havoc,

just try like this,

replace ',' WITH ' ' INTO v_menge.

CONDENSE V_MENGE NO-GAPS.

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 04:25:18 GMT

Hi,

Move the Amount field to Char field.

If you have the amount value in char field.

REPLACE ALL OCCURRENCES OF ',' IN CHAR WITH space.
CONDENSE CHAR NO-GAPS.

If you amount field and want to move to char field..

Char = amount. " The char field will not have the thousand seprators

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 04:27:21 GMT

Hello,

You can use the translate statement to do this.

w_abc = 12,000,000.00.

translate w_abc using ', '.

Condense w_abc no-gaps.

Thanks,

Sowmya

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 04:36:13 GMT

hi:

do like this

data amt type n

write amount to amt.

it would remove commas.

Regards

Shashi

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 05:26:19 GMT

Hi,

Use the NO-GROUPING Write add on functionality.

Please check the below code.

data: num1(12) type P decimals 2 value '1200000.00',

num2(12) .

write : / 'num1',num1.

write num1 to num2 no-grouping.

write: /'num2',num2.

Hope this will help you..

Regards,

Smart Varghese

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 06:54:36 GMT

Hi,

Please follow the bellow procedure to replace comma from amount.

data: l_amount(16) type c.

move amount to l_amount.

REPLACE ALL OCCURRENCES OF ',' IN l_amount with '''.

Re: separate commas from amount

Former Member — Tue, 02 Jun 2009 08:35:55 GMT

Hi,

Comma in 12,000,000.00 is a user default seperator.

Get this user default seperator using FM CLSE_SELECT_USR01 and then replace this seperator with space and then use condence for variable.

Define Amt as char field and amount to amt field.


  call function 'CLSE_SELECT_USR01'
       exporting
            username     = sy-uname
       importing
            decimal_sign = gv_dec_sep
            separator    = gv_tho_sep
            date_format  = gv_date_format.
REPLACE ALL OCCURRENCES OF gv_tho_sep IN Amt with space.
condence Amt.

Regards,

Raju.

Re: separate commas from amount

SujeetMishra — Wed, 03 Jun 2009 04:09:44 GMT

Hello,

Use NO-GROUPING.

Regards,

Sujeet