In Wrangle transformations that support use of regex patterns, you may need to specify capture groups. A capture group is a pattern that describes a set of one or more characters that constitute a match.
- These patterns are described using regular expression syntax. Trifacta Wrangler Enterprise implements a version of regular expressions based off of RE2 and PCRE regular expressions.
This section contains information on how special capture group references are managed.
Dollar sign in replace transform
The dollar sign ($) is used as a form of escape character in the
with parameter of the
replace transform. This pattern identifies the replacement string.
In the table below, you can review how these replacement patterns are supported across the running environments.
|Pattern||Description||On Photon||On Hadoop|
|Inserts a ||Yes||Yes|
|For non-negative digits ||Yes||Yes|
In the following example, the
MyColumn column contains the value
foobar in all rows.
Note that the
Positive and Negative Lookaheads
In regular expressions, you can use positive and negative lookahead capture groups to capture content that is conditionally followed or not followed by a specified capture group.
|Positive lookahead||Capture the letter |
|Negative lookahead||Capture the letter |
This page has no comments.