Exclude from List Box with 'NOT LIKE'

[#1]

Hi everyone,

I'm trying to filter the values in a list box based on where the value is NOT LIKE 'INF'

The query works when I say  =if([ID] like '*INF*', [ID])

But it won't allow  =if([ID] not like '*INF*', [ID])

Can someone please help with the correct syntax?

Thanks!!

[alexandros17]

=if(wildmatch([ID], '*INF*'') > 0, [ID], '')

[salto]

Hello,

     maybe changing the "then" and "else" order, like this:

     =if([ID] like '*INF*', [Else value], [ID])

     Or maybe this:

     =if not ([ID] like '*INF*', [ID])

Hope this helps.

[#4]

Awesome thanks so much!! I changed it to

= if(wildmatch([HFL FSAM ID], '*INF*') <> 1,[HFL FSAM ID])

to exclude the blanks as well and it works perfectly!!

Thanks again for the super quick response!

[jagan · Accepted solution]

Hi,

Try this simple one

=If(WildMatch([ID], '*INF*''), [ID])

Regards,

Jagan.