String Manipulation - Finding and Getting Text

[Former Member]

I have two tasks to do:

1. "NINE HUNDRED EIGHTY-NINE Rupees NINETY Paise" --> what I want to do is find "Rupees" from the text and delete starting from "Rupees" until the end of the text.

2. "989.90" ---> I want to find the position of "." and get everything beyond that point so i can get just "90"

Thanks! Credits will be given

[Former Member]

Hi Jill,

Try this.....

data: rs(100) type c,

rs1(100),

ps1(100).

rs = 'NINE HUNDRED EIGHTY-NINE Rupees NINETY Paise'.

SPLIT rs AT 'Rupees' into rs1 ps1.

write: rs1.

**Reward if useful

Regards,

Archana

[Former Member]

thanks this worked!

[former_member195698]

Try this.

1) Use the Keyword Search. It will give you the position of the required word in SY-FDPOS.

data:wf(100) type c.

wf = 'eight hundred fifty rupee five paisa'.

search wf for 'rupee'.

write : wf+(sy-fdpos).

2) Move The Number to a character field. Use SPLIT at '.' into two variables. The first character field will give you the required number.

Message was edited by:

Abhishek Jolly