Im trying to do a multiple string search in button properties

[Anonymous]

Im trying to do a multiple string search in button properties, to make things worse, the strings also have spaces.

I could filter one search A. 10 - 15K but i can't join two together, i've tried piping them together and * for the spaces.

(A.*10*-*15K|B.*15*-*20K)

Much needed help

Many thanks in advance

[Nicole-Smith]

I believe you need to replace any special characters.  I always replace mine with a question mark, but I wouldn't see why the * wouldn't work as well.

So try either:

(A*10*15K|B*15*20K)

or

(A??10???15K|B??15???20K)

[Anonymous]

Still not working, thanks

[#4]

Have you tried putting double quotes around it like this ("A.*10*-*15K"|"B.*15*-*20K")

[Nicole-Smith]

Both options work for me (see the attached).

[maxgro · Accepted solution]

Hi

try with

='("ba*"|"*de*")'

see attachments

[Anonymous]

Never worked, tbh i've tried so many variations, could the file be corrupt? it seems to be running fine, everything else is filtering through fine

Thanks anyway

[Anonymous]

Massimo you star!

[Anonymous]

Guys, i think all your suggestions work(mine worked on other files), some were working on my mates pc and not on mine.

[maxgro]

Nicole your example works for me too