How to combine two wildcard searches?

[nicktodd]

I've got a document that queries a list of computers each of which have a name like

JFB999-B999-a9999

where 'a' can be 'W','E','A','S','E','X'

I want to find all 'E' or 'X' type computers, i.e. that match

JFB*-E*

or

JFB*-X*

and ideally have that search on a button that the users can click but I can't figure out how to combine the two wildcard searches.

Any ideas welcome!

Thanks

Nick

[#2 · Accepted solution]

Hi Nick

This one (a few years ago now) took my what seemed like a lifetime to work out, because I couldn't find any documentation of the syntax, but anyway, here's how you do it.

Add an action to the Button:

Select in Field, ComputerName then in the Search string put in: (JFB*-E*|JFB*-X*)

Hope it helps.

[jagan]

Hi,

Is the format of all list of computers are same? 

Ex: JFB999-B999-a9999

Regards,

jagan.

[nicktodd]

Brilliant - thanks! I was trying all ways....

[nicktodd]

Jagan

No, not all - some have a completely different naming convention. Nigel has found a solution that seems to work.

Cheers

Nick