supports the following types of text matching clauses:

Tip: You can create patterns to match source values in a column by example. By providing example matches for values in your source column, you can rapidly build complex pattern-based matches. For more information on transformation by example, see Overview of TBE.

The following are example :

Tip: After using , regular expressions, or string literals in a recipe step, you can reuse them in your transformations where applicable. See Pattern History Panel.

%match any character, exactly once
%?match any character, zero or one times
%*match any character, zero or more times
%+match any character, one or more times
%{3}match any character, exactly three times
%{3,5}match any character, 3, 4, or 5 times
#digit character [0-9]
{any}match any character, exactly once
{start}match the start of the line
{end}match the end of the line
{alpha}alpha character [A-Za-z_]
{upper}uppercase alpha character [A-Z_]
{lower}lowercase alpha character [a-z_]
{digit}digit character [0-9]
{delim}single delimiter character e.g :, ,, |, /, -, ., \s
{delim-ws}single delimiter and all the whitespace around it
{alpha-numeric}match a single alphanumeric character
{alphanum-underscore}match a single alphanumeric character or underscore character
{at-username}match @username values
{hashtag}match #hashtag values
{zip}, {hex}, {phone}, {email}extensible types, as regexes
{state}, {state-abbrev}extensible types continued
{month}, {month-abbrev}, {url}extensible types continued
{ip-address}, {hex-ip-address}extensible types continued
{time}, {bool}extensible types continued
{[...]}character class matches characters in brackets
{![...]}negated class matches characters not in brackets
(...)grouping, including captures
#, %, ?, *, +, {, }, (, ), \, ’, \n, \tescaped characters or pattern modifiers Use a double backslash (\\) to denote an escaped string literal. For more information, see Escaping Strings in Transforms.
|logical OR

See also Capture Group References.