- Excel Desktop Client new !
SEARCH performs a search to see if one string is present within another.
SEARCH may test whether a string starts, ends or contains another string.
SEARCH may find the position within the string of the first or last occurrence of the search string.
The search string Search Text: will often contain one or more object references. Any LIST references here are EXPAND'd to create a SCALAR before any matching is done.
A regular expression provides an advanced template or pattern for matching text.
|Choose a SCALAR from drop-down list to match to Search Text:.
|The text to compare with Value:, object reference(s) allowed
|String match operation (CONTAINS, ENDS WITH, EQUALS, FIRST, LAST, STARTS WITH)
|Character to delimit an object reference in Search Text: above. default→ %
|Allow Regular Expressions:
The following examples use a SEARCH called search1