topic To delete commas in Application Development and Automation Discussions

To delete commas

Former Member — Fri, 29 May 2009 14:14:44 GMT

Hi Experts,

I am calling 'fm' to convert digit amount in words but its giving error as amount conatins commas so plesae tell me to delete commas in amount.

thank you.

Re: To delete commas

Former Member — Fri, 29 May 2009 14:17:42 GMT

Hi,

try this way...it will work


replace all occurrences of ',' in w_currency with ' '.
condence w_currency  NO-GAPS.

Regadrs,

Prabhudas

Re: To delete commas

Former Member — Fri, 29 May 2009 14:18:32 GMT

Hi,

You can use the command like,

REPLACE all the occurances of ',' with SPACE, in the given work area.

Regards,

Santhosh.

Re: To delete commas

Former Member — Fri, 29 May 2009 14:19:42 GMT

well...how many commas u have ..if u have 1 comma just use split and move the values into two variables and use concatenate to join them into one variable and pass that into function module for words.hope this helps

Re: To delete commas

Former Member — Fri, 29 May 2009 14:27:50 GMT

Hi Saalim,

do you want to delete the comma:

e.g. 220,20 x 100 = 220220

newvalue = amount x 100.

if you want ot replace it you have to use a variable type c :

replace ',' with ' ' into ztext.

regards

Uwe

Edited by: Uwe Cappeller on May 29, 2009 4:28 PM

Re: To delete commas

Former Member — Fri, 29 May 2009 14:30:54 GMT

Hi Saalim,

Declare your field your currecy type then you can avoid comma's or else just use split or replace command for comma's and then use this function module,

CALL FUNCTION 'HR_IN_CHG_INR_WRDS'

EXPORTING

amt_in_num = l_tmp

IMPORTING

amt_in_words = p_g_words

EXCEPTIONS

data_type_mismatch = 1

OTHERS = 2.

Re: To delete commas

Former Member — Sat, 30 May 2009 03:05:55 GMT

hi,

its solved my problem.

thank you.