Checking a string for string pattern

building reports desktopintelligence
1

I have a spreadsheet that I have opened in business objects so I can use the data alongside data from a universe.

The spreadsheet has a ‘description’ field that is now an object called in business objects. This contains long text strings.

From that object I need to find all rows that contain within their text string ‘BEL/LUX’. This does not always appear in the same place in the string so SUBSTR does not work.

In Excel I would use a formula like

ISNUMBER(FIND(“BEL/LUX”,C1))

which would return the value ‘True’ for any row where the string contained the letters specified.

In BO i have tried

IF (MATCH(,"%BEL/LUX%")) Then “TRUE” ELSE “FALSE”

but this does not work.

Is there a way to do this in BO?

hem852 (BOB member since 2006-08-07)

2

Hi,
I guess I tried this and it worked
Make a variable and put this code in it( you can customize the code as you want)

=If( Match("<1st Proposer Full Name>|" ,"%Allen%")) Then 1 Else 0
then drag this variable in the report and then you can filter the values you want.
Hope this helps.
Cheers!!!

harpreet_lucky (BOB member since 2006-04-24)

3

Hi :slight_smile:
Use the following formula to check the position of ‘BEL/LUX’
=Pos( ,“BEL/LUX”)
It returns the position number of ‘BEL/LUX’. If its not present then it will display 0 values. Then hide where its 0 using Format -> Filters
and define = <> 0.

Prashu :india: (BOB member since 2005-08-17)

4

Hi,
Gr8 that might will also work.
Cheers!!

harpreet_lucky (BOB member since 2006-04-24)

5

Thank you both. Much Appreciated.

hem852 (BOB member since 2006-08-07)

6

Hi,

i have seen other posting about “match” function with * instead of % and * works in our case. We are on BO 6.5.

Regards,
Alex

agrubman (BOB member since 2006-02-21)

7

BO is all goofed up. * worked for me too in place of %.
Dunno why they have said in the documentation that % is to be used.

Manish

myloginid (BOB member since 2007-03-27)

8

Stephen had a great suggestion concerning the Match () function. His suggestion is posted under Desktop Intelligence (XI Release 2).

He suggest the use of Pos () instead of Match (). I was able to implement his suggestion in BO (6.5.1).

Cheers!!!

jgibbsatnd (BOB member since 2007-03-28)