sap - Testing string contents -

sap - Testing string contents -

is there function in business objects web intelligence (version 2010) test if string contains constant? know match() function can used test string pattern, similar how sql implements condition.

for example:

mystring = 'abc,def,ghi' mystring2 = 'def,ghi,jkl'

both string variables above contain constant 'def', there function test rather using:

=if(match([dimension];"def") or match([dimension];"*def") or match([dimension];"def*") or match([dimension];"*def*")) //do

i have looked through functions , formulas manual , haven't found looking for, hence, here am.

match([dimension];"*def*")) produce result need. wildcard match origin of string.

alternatively, can utilize pos():

=pos("def abc ghi";"def") returns 1

=pos("def abc ghi";"abc") returns 5

=pos("def abc ghi";"xyz") returns 0

sap business-intelligence business-objects