topic Re: decimal points in Application Development and Automation Discussions

decimal points

Former Member — Thu, 14 Aug 2008 07:51:56 GMT

i have a string 123,45,0.89.

my requirement is to identiy the commas

where exactly it is and need to delete the

commas.the string i am getting from the flat file,so the

commas maybe at the third and 5th position or etc.

so i cannot predict the commas where they are.so what ever the

string is i need to delete the commas and period should be there ie

decimal should be the there.

so tell me how to handle this.

Former Member — Thu, 14 Aug 2008 07:54:50 GMT

Dear,

Read this string and split the string and loop at that string check it with ',' if sy-subrc = 0 delete ',' and endloep.

Thanks,

jaten

kiran_k8 — Thu, 14 Aug 2008 07:56:53 GMT

Jaten,

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

K.Kiran.

Former Member — Thu, 14 Aug 2008 07:57:53 GMT

Hi,

You can use the REPLACE ALL OCCURANCE and CONDENSE statements to achieve this.

REPLACE ALL OCCURRENCES OF ',' IN var1 WITH ' '.

condense var1.

now var1 will not have any comma in it.

RahulKeshav — Thu, 14 Aug 2008 07:59:58 GMT

Hi MN,

you can read the string and

replace all occurrences of ',' in string with space.

condense string no-gaps.

thnx

Rohit

Former Member — Thu, 14 Aug 2008 08:10:37 GMT

hii

you can use like follow code

loop at itab into wa_itab.

wa_value = wa_itab-currency.

REPLACE ALL OCCURRENCES OF ',' IN wa_value WITH '.'.

endloop.

regards

twinkal