How do you filter on whether a string has the word "saf

building reports webintelligence
1

in it?

I only want to display work orders in a block that have the word “safety” in them, but I can’t seem to make a filter that works.

thanks,
Tim

tbrown7777 (BOB member since 2007-05-23)

2

Make a variable that uses the Match() function, and then filter on that variable. Something like:

=If(Match([your_var_here];"*safety*");1;0)

Then create a report filter that checks to see if that variable has the value of 1.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

thanks. that works great!

tbrown7777 (BOB member since 2007-05-23)