Spliting a string

[Former Member]

Hi all,

I have to split the string abc/def into abc def

i splited it into abc def but when the value in filed is suppose ram then it is giving error because there in no delimator and no 2nd string.how to do it.

Thanks,

neetu

[Former Member]

Try this formula

if instr({string field},"/")>0 then
split({string field},"/") [1]

Regards,

Raghavendra

[Former Member]

Hello Neetu,

there are several ways to operatte with strings :

Plese see some possibilities below :

{file.FIELD} startswith "C"

Selects those records in which the value in the {file.FIELD} field begins with

the character "C" (includes values like CyclePath, Corp. and Cyclist's Trail

Co.; excludes values like Bob's Bikes Ltd. and Feel Great Bikes, Inc.).

not ({file.FIELD} startswith "C")

Selects those records in which the value in the {file.FIELD} field does not

begin with the character "C" (includes values like Bob's Bikes Ltd. and Feel

Great Bikes, Inc.; excludes values like CyclePath, Corp. and Cyclist's Trail

Co.).

"999" in {file.FIELD}[3 to 5]

Selects those records in which the 3rd through 5th digits of the {file.FIELD}

field is equal to "999" (includes values like 10999, 70999, and 00999; excludes

values like 99901 and 19990).

Please see a full description in this [CR User Guide 08|http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_cr_usergde_en.pdf] starting page 207 and the following .

Hope this helps

Falk