# List of string functions

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

String functionsString functions

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