optionparameter identifies that the pattern to match is a custom one specified by the user.
Number of matches to extractparameter defaults to
1, meaning that the transformation extracts a maximum of one value from each cell. This value can be set from 1-50.
Extract values by example
You can generate a new column of values extracted from a source column by entering example values to match with source values. Values with similar patterns may also be matched based on your entered example value.
Tip: This method provides an easy way to build pattern-based matching for values in a source column.
For more information on transformation by example, see Overview of TBE.
Within the extract transformation, you can specify literals or patterns before or after which the match is found. This method can be used to remove parts of each cell value from erroneously matching on the literal or pattern that is desired.