Wild card searching

building reports webintelligence
1

I have to do a name search and I am using the wild card function. I need to do the search from a long list on an Excel spreadsheet. I am using the % character on all the names to denote the wildcard. I know how to bring the spreadsheet into BO. How to go from there?

JC_01 (BOB member since 2015-09-24)

2

To search in a string you can do


My Variable
=If(Pos([My dimension];"My Value")>0;1;0)

From there you can retrieve the “My Value” from an Input Control. Create a variable (Var1) with this code in

=""

Then create an Input Control with Entry Field based on that variable. You then create your “My Variable” like this

=If(Pos([My dimension];[Var1])>0;1;0)

You can also filter the block where My Variable= 1

To make it more stable, put everything in lower case

=If(Pos(lower([My dimension]);lower([Var1]))>0;1;0)

Derf :canada: (BOB member since 2011-05-16)