topic Re: Replace Text into Amount in Application Development and Automation Discussions

Replace Text into Amount

former_member184112 — Mon, 31 Mar 2008 04:10:17 GMT

Hi,

SAP Script Req:

Amount in words..but requires this in Numeric without any comma or dot..

example 2,200 to 2200

this amount may get higher amount for any other postings

example 1,22,300 that means it should display as 122300

and also i need space between each number.

How it is posible..this is very urgent

Thanks and Regards,

Prabhakar Dharmala

Re: Replace Text into Amount

Former Member — Mon, 31 Mar 2008 04:14:39 GMT

HI,

CALL FUNCTION 'SPELL_AMOUNT'
     EXPORTING
          amount   = int_betrag
          currency = par_waer
     IMPORTING
          in_words = up_spell
     EXCEPTIONS
          OTHERS   = 1.

Regards,

Brown.

Re: Replace Text into Amount

former_member184112 — Mon, 31 Mar 2008 04:17:03 GMT

Hi,

I want this in Reverse

in Words to Number

Thanks and Regards,

Prabhakar Dharmala

Re: Replace Text into Amount

Former Member — Mon, 31 Mar 2008 04:22:28 GMT

Hi,

To remove comma, you can use the following piece of code:

in the text editor:

/: PERFORM REMOVE_ASTERISK IN PROGRAM ZFI1_CHECKFORM

/:USING &REGUH-ZANRE&

/:USING &REGUD-SWNES&

/:USING &REGUH-ZNME1&

/:CHANGING &V_NAME1&

/:CHANGING &V_TOTALAMT&

/:CHANGING &V_NAME2&

/:ENDPERFORM

in the program

Write a code to replace all occurances of ','.

You can make use of

Replacing the occurrences of '*'

REPLACE ALL OCCURRENCES OF ',' IN zswnes WITH space.

reward points if helpful.

thanks,

asha

Re: Replace Text into Amount

ak_upadhyay — Mon, 31 Mar 2008 04:26:04 GMT

Hi,

Use FM...

SPELL_AMOUNT

Reward points if useful....

Regards