Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Trifacta® Wrangler supports a set of special characters for regular expressions that are common to all of the execution engines supported by the platform.

In regular expressions, the backslash character is the escaping character. It can be used to denote an escaped character, a string, literal, or one of the set of supported special characters.

Supported Special RegEx Characters

The table below identifies the special characters that are supported in the platform.

Special CharactersDescription
\\String literal match for \ character.

\b

Matches any zero-width word boundary, such as between a letter and a space.

Example: /\bre/ does not match re in tire , since re is not on the word boundary. /re\b/ does match.  

\B

Matches any zero-width non-word boundary, such as between two letters or two spaces.

Example: /\Bre/ matches re in tire. It does not match in respect, since that instance of re is on a word boundary.

\cX Matches a control character (CTRL + A-Z), where X is the corresponding letter in the alphabet.
\dMatches any digit.
\DMatches any non-digit.
\fMatches a form feed.
\nMatches a line feed.
\rMatches a carriage return.
\s

Matches any whitespace character. These characters include:

  • space
  • tab
  • form feed
  • line feed
  • Other Unicode space characters
\SMatches any character that is not one of the supported whitespace characters.
\tMatches a horizontal tab.
\v

Matches a vertical tab.

\w

Matches any alphanumeric value, including the underscore.

Tip: Column names must match the same set of characters.

\WMatches any non-alphanumeric character, including the underscore.
\xHH Matches the ASCII character code as expressed by the hexadecimal value HH.
\uHHHHMatches the Unicode character code as expressed by the hexadecimal value HHHH .

 

Required Escaped Characters

The following characters have special meaning within a regular expression.

. ^ $ * + - ? ( ) [ ] { } \ | — /

To reference the literal character, you must escape it within the regular expression, as in:

/\./

Your Rating: Results: PatheticBadOKGoodOutstanding! 2 rates

This page has no comments.