Examples of Using Wildcards and Quotation Marks for Searches on the Page
The following scenarios provide examples of using wildcards and quotation marks in search fields on the page. Actual search results may vary, depending on factors such as how the search is set up or what data is available.
In most cases, the search field isn't case sensitive.
Using Quotation Marks
In searches with a single field for search terms, enter multiple words with quotation marks to get records that have the exact phrase. For example, if you search for "currency code", then only records with the exact phrase currency code are included in the search results.
Using Wildcards
Use the percent (%) wildcard to get records that replace the wildcard with zero or more characters. Use the underscore (_) to replace the wildcard with exactly one character.
-
Enter % or _ at the beginning (only in search fields that are conditionally required or not required), middle, or end of a word.
Caution:Using a wildcard at the beginning of a word can affect performance.
-
You can use the wildcard more than once in one word.
-
If the search criterion has an operator, you must select Starts with or Contains for the wildcard to work.
-
To include % or _ in your search results, precede the symbol with a backslash (\) when you enter the search term. The symbol won't act as a wildcard, but as any other character in your search term.
If you're using an operator other than Starts with or Contains, then you don't need to precede % or _ with \, for the same effect.
This table shows some wildcard examples.
Search Term |
Matches |
---|---|
add% |
|
exp_nse |
Words such as expense or expanse |
e_p% |
Words such as especially or experience |
amount \% |
The phrase amount % |
In some cases, the _ wildcard might not match spaces or symbols that separate words. For example, currency_code might not match currency code or currency/code.