Search Function

[#1]

Hi,

I have concatenated 8 fields into one field to enable the user to 'wildcard' search only these fields for a particular value.  Since giving the user this option, they have asked if it is possible to search this field for two different values.  I have said that this inst possible using the current search facility is this correct?

Thanks for any help

[marcus_sommer]

You could combine several wildcard-searches with this syntax:

("*value1*"|"*value2*")

- Marcus

[jonathandienst]

I assume that you are searching in a list box. You can enter multiple criteria using the syntax

     (search1|search2)    where searchn can contain * as a wildcard

For example values contain "hello" or "goodbye"   (*hello*|*goodbye*).

Quote the search strings if they contain spaces.

[jonathandienst]

If the users find this confusing, train them to search and select the first value, then search and ctrl-select the second value.

You might want to consider using the Search sheet object, which can search multiple fields at once. Then it will not be necessary to create a concatenated search string which will of necessity be both long and have a high cardinality - both of which can impact performance on a large models.