String Functions
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 utilizeWrangle 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.