Multiple Wild Card * * searches?

[NickHoff]

Hello,

I have a user who wants to search a wildcard search field with multiple items.

We tried *item number1* | * item number2* | *item number3*, but had no luck.

as well as *item number1* & *item number2* & *item number3* with the same results.

It will work if we don't have the wild card search in there, but unfortunately they'll need it.  Is this possible?

[qv_testing]

Use Wildmatch function...

Like

wildmatch (field name,  '*itemnumbet*', *itemnumber2*')

[sunny_talwar · Accepted solution]

May be this

("*item number1*"|"*item number2*"|"*item number3*")

[Digvijay_Singh]

I think you are suggesting wildmatch -

wildmatch( M, 'ja*','fe?','mar')

[Chanty4u]

instead try this ?

Goto the  Listbox Properties --> General

You can try the "Use Wildcard Search" in Default Search Mode

[NickHoff]

I'm not looking for wildcard match.  I'm referencing the object the user is searching on, i.e. they click a multi-box drop down and start typing to search for a field.  They are using the wildcard search by adding * before and after the data they are searching for.

[NickHoff]

Yes, this is what i'm referring to, it will default the * before and after the search criteria.  However, it's only allowing to search one item when the user needs to create a bookmark with hundreds.

[NickHoff]

I tried this and it didn't work as well.

[sunny_talwar]

Look here

Compound Search - demystified

[swuehl]

Sunny's search term using the compound search should work.

You need to enter the compound search exactly as shown.