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:
Info |
---|
NOTE: Depending on the type of transform, some of these clauses are not available. |
Positioning

D caption |
---|
|
Pattern Clause Positioning |
after
Identifies pattern or string after which the match is evaluated.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 'eat ' |
---|
Type | step |
---|
WrangleText | extract type: on col: MySentence start: 'eat ' |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | On pattern |
---|
p03Name | After pattern |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
Code Block |
---|
pizza on Fridays with my friends." |
from
Identifies pattern or string from which the match is evaluated. Any match includes the from
clause pattern or string.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 'eat ' |
---|
Type | step |
---|
WrangleText | extract type: between col: MySentence start: 'eat ' includeStart: true |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | Between two parameters |
---|
p03Name | After pattern |
---|
p04Value | true |
---|
p04Name | Include as part of match |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
Code Block |
---|
eat pizza on Fridays with my friends." |
before
Identifies pattern or string before which the match is evaluated.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 'friends' |
---|
Type | step |
---|
WrangleText | extract type: on col: MySentence end: 'friends' |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | On pattern |
---|
p03Name | Before pattern |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
Code Block |
---|
"I like to eat pizza on Fridays with my |
to
Identifies pattern or string up to which the match is evaluated. Any match includes the to
clause pattern or string.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 'friends' |
---|
Type | step |
---|
WrangleText | extract type: between col: MySentence end: 'friends' includeEnd: true |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | Between two patterns |
---|
p03Name | Before pattern |
---|
p04Value | true |
---|
p04Name | Include as part of match |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
Code Block |
---|
"I like to eat pizza on Fridays with my friends |
on
Identifies pattern or string in which the match may be found.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 'Fridays' |
---|
Type | step |
---|
WrangleText | extract type: on col: MySentence on: 'Fridays' |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | On pattern |
---|
p03Name | Match pattern |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
at
Identifies the index of starting (x) and ending (y) characters in the string to match. In the above example, at:2,6
matches the string like
.
Example transformation:
D trans |
---|
RawWrangle | true |
---|
p03Value | 2,6 |
---|
Type | step |
---|
WrangleText | extract type: at col: MySentence at: 2,6 |
---|
p01Name | Column |
---|
p01Value | MySentence |
---|
p02Name | Option |
---|
p02Value | Between two positions |
---|
p03Name | Positions |
---|
SearchTerm | Extract text or pattern |
---|
|
Extracts:
Pattern Parameter Interactions
The following table identifies the pattern parameters that can be matched with the parameter in the left column.
Info |
---|
NOTE: The at parameter does not interact with any of the listed parameters. |
Parameter | after | from | before | to | on |
---|
after | See Note 1. | No. | before or to | before or to | Yes. Can include before . |
from | No. | See Note 1. | before or to | before or to | No. |
before | after or from | after or from | See Note 1. | No. | Yes. Can include after . |
to | after or from | after or from | No. | See Note 1. | No. |
on | Yes. Can include before . | No. | Yes. Can include after . | 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.