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 utilize Cloud Dataprep 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:

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation
Need help? Visit our support page.