Splitting a text

[Former Member]

Hi,

I have a text as below with '/ ' (slash) symbol between the text.

sap India ltd / erpsdsjh / sddgfdg / 543

Now, I want to get sap India ltd into one variable. ie, till the first /. I don't want the text after the first /.

There can be any number of '/ ' symbols in the text. In that I want the text before first / symbol.

How to get the text till the first /.

Can anyone help me on how to do this.

Thanks in advance.

Best regards,

Paddu.

Edited by: Paddu K on Jan 19, 2008 3:53 AM

[former_member191735]

if string ca '/'.

use split commad to store into two variables. Make sure the two variables are string type

SPLIT dobj AT sep INTO

{ {result1 result2 ...} | {TABLE result_tab} }

[IN {BYTE|CHARACTER} MODE].

You will have the first word before '/' in first variable.

[Former Member]

Use the SPLIT statement and split the string at '/' into two variables. Discard the second variable and use the first variable.