- Excel Desktop Client new !
REPEATED SEARCH performs search operations on each string in a LIST.
REPEATED SEARCH may test whether a string starts with, ends with or contains another string.
REPEATED SEARCH may find the position within each string in a LIST of the first or last occurrence of the search string in Search Text:
Search Text: may contain SCALAR's or LIST's of the same length as the input LIST in Value:. The resulting REPEATED SEARCH will also be this length.
A regular expression provides an advanced template or pattern for matching text.
|Choose a LIST from drop-down list to iterate through.
|Text or regular expression to match, delimited object references allowed
|Select operation (CONTAINS, ENDS WITH, EQUALS, FIRST, LAST, STARTS WITH)
|Character to delimit an object reference in Search Text: above, default→%
|Allow Regular Expressions: