Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

A string is any sequence of characters. The following values can all be treated as strings:

myStrings
Jack Jones
123
true
NY

Tip: Any value can be a string. So, you can change the data type of any column to string to use these functions. In some cases, however, it is easier to use other functions that are designed for the original data type. Make sure you switch the type back after completing your string manipulation.

String functions perform operations on text data. Based on column or string literal inputs, these functions render outputs that provide a subset of the input, convert to a different format or case, or compute metrics about the input. These functions are very useful for manipulating strings. 

  • Some string functions utilize Trifacta® patterns and regular expressions to identify patterns to match.
  • Depending on the type of string function, some types of string literals or patterns might not be supported.

For more information on these expressions, see Text Matching.

Topics:

 

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 10 rates

This page has no comments.