List of string functions
| Name | Description |
|---|---|
| Add extra characters | Adds extra characters (padding) on the left or on the right of the original value to match an expected size |
| Calculate length | Extracts the number of digits from a value (23562 -> 5) |
| Change to lower case | Converts all of the cell text in this column to lower case |
| Change to title case | Converts the text content from this column to title case (i.e. "this is an example" -> "This Is an Example") |
| Change to upper case | Converts all of the cell text in this column to UPPER case (capitalize) |
| Contains text | Checks if the cell contains the specified value |
| Convert character width | Converts the character width to half or full width, or normalize strings |
| Extract a value by index | Extracts part of the text (substring) to a new column |
| Generate unique identifier (UUID) | Generates a unique identifier for each row of the column |
| Match pattern | Creates a new column with true or false depending on whether the value matches a given pattern |
| Match similar text | Creates a new column with true or false depending on whether the value is less than or equals the Levenshtein distance of a given value |
| Remove all non alpha numeric characters | Cleans values that contain unexpected characters
by removing all characters that are not 0-9, Aa-Zz, and accented letters.
Whitespaces are kept. For example, T=+Âl**€en#d$ 20%1,7 will become TÂlend 2017. |
| Remove all non numeric characters | Cleans numeric values by removing all characters that
are not 0-9. Decimal separators and whitespaces are kept. For example, T=+Âl**€en#d$ 20%1,7 will become 201,7. |
| Remove consecutive characters | Removes consecutive repeated characters |
| Remove part of the text | Removes specified text from cells in this column |
| Remove trailing and leading characters | Removes trailing and leading spaces or other specified characters (i.e. trim) |
| Search and replace | Replaces cells or parts of cells which contain a specific value |
| Simplify text (remove case, accent, etc.) | Simplifies the content of the column by putting it in
lower case, removing accents, normalizing using NFKD, splitting combined
characters and trimming the whole string. For example, François becomes francois. |