Pattern Clause Position Matching
For a number of different transform types, you can specify the limits at which any match is valid for a text string. In the diagram below, you can see how six different positional identifiers can be applied to pattern matching:
Note
Depending on the type of transform, some of these clauses are not available.
Positioning
![PatternPositionClausesDiagram.png](../../../../image/uuid-c9d99539-0b6d-dc1d-39dd-7424b382bf50.png)
Figure: Pattern Clause Positioning
Identifies pattern or string after which the match is evaluated.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | On pattern |
Parameter: After pattern | 'eat ' |
Extracts:
pizza on Fridays with my friends."
Identifies pattern or string from which the match is evaluated. Any match includes thefrom
clause pattern or string.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | Between two parameters |
Parameter: After pattern | 'eat ' |
Parameter: Include as part of match | true |
Extracts:
eat pizza on Fridays with my friends."
Identifies pattern or string before which the match is evaluated.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | On pattern |
Parameter: Before pattern | 'friends' |
Extracts:
"I like to eat pizza on Fridays with my
Identifies pattern or string up to which the match is evaluated. Any match includes theto
clause pattern or string.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | Between two patterns |
Parameter: Before pattern | 'friends' |
Parameter: Include as part of match | true |
Extracts:
"I like to eat pizza on Fridays with my friends
Identifies pattern or string in which the match may be found.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | On pattern |
Parameter: Match pattern | 'Fridays' |
Extracts:
Fridays
Identifies the index of starting (x) and ending (y) characters in the string to match. In the above example,at:2,6
matches the stringlike
.
Example transformation:
Transformation Name |
|
---|---|
Parameter: Column | MySentence |
Parameter: Option | Between two positions |
Parameter: Positions | 2,6 |
Extracts:
like
Pattern Parameter Interactions
The following table identifies the pattern parameters that can be matched with the parameter in the left column.
Note
The at
parameter does not interact with any of the listed parameters.
Parameter | after | from | before | to | on |
---|---|---|---|---|---|
after | See Note 1. | No. |
|
| Yes. Can include |
from | No. | See Note 1. |
|
| No. |
before |
|
| See Note 1. | No. | Yes. Can include |
to |
|
| No. | See Note 1. | No. |
on | Yes. Can include | No. | Yes. Can include | No. |
Note 1: If there is no other pattern parameter in the transform, the maximum number of matches per cell is 1. If there is a matching parameter, more matches per cell can be found.