Filtering for buried text

[ShawnMe]

Is there a way to create a report filter that find text that is not standalone?  My filter is project name contains SR:,  but it is not finding those names that have an underscore before the searched-for text (eg. 00_SR:).  In FileMaker (my previous tool) I would use an asterisk to represent "wildcard" text — *SR: would find the text SR:, whether standalone or appending other text.  Is there an equivalent way to do this in Workfront?

[Richard_Le_ · Accepted solution]

Hi,

Instead of using a "contains" filter modifier, I suggest trying a "like" or "cilike" modifier. Like modifiers work similarly to contains modifiers, but they enable you to insert wildcard characters to break up the text. So your filter would look something like this in text mode:

name=%sr%
name_Mod=cilike

You can read more on filter modifiers and how they are used here.

Best Regards,

Rich.

[ShawnMe]

Thanks, Richard!  This looks to be exactly what I am looking for.  I will give it a try.

Shawn

[ShawnMe]

Worked perfectly!  Thanks again.