The purpose of this statement is to find text in one or more fields, a named variable or each field named in a list in a named variable and to optionally remove the specified pattern and all text before or after the pattern. Which fields or text strings you are processing is discussed in Statement Source/Target Determination. The same topic describes the ability to treat each field or named variable as a list where each list component will be processed.
You can optionally choose to ignore alphabetic case and/or diacritical marks while searching.
You can also choose to search backwards as opposed to forwards by setting the From end option.
When replacing in a list and the delimiter evaluates to an empty string at runtime, a default (\~) will be assumed.
If the then trim whitespace characters option is set, every modified value will have leading and trailing whitespace characters removed.
The supplied strings may contain any of the escape sequences described in Escape Sequences. If the resolved pattern is empty the operation does nothing.
If any changes occurred, the action test state will be set to true, otherwise it will be set to false.
Field Selection Modes in Tables
Information on alternate means of parsing or scanning