Configuration
Select Column(s)
Select the column(s) you want to transform. You can choose multiple columns at the same time.
Select Transformation
Choose how you would like to change your column(s) from the options below:
| Option | Description | Column format requirement |
|---|---|---|
| Upper Case | CHANGES COLUMN CONTENT TO UPPERCASE | Text |
| Lower Case | changes column content to lowercase | Text |
| Title Case | Changes Column Content To Titlecase | Text |
| Left | Get the first x number of characters of a column | Text |
| Right | Get the last x number of characters of a column | Text |
| Length | Set the maximum x number of characters of a column | Text |
| Round | Round a numeric column to x number of decimals | Numeric |
| Ceil | Round up to nearest integer/whole number | Numeric |
| Floor | Round down to nearest integer/whole number | Numeric |
| Trim | Remove trailing/leading whitespace and tabs | Text |
| Escape Special Characters | \n show tabs as \n | Text |
| Remove special characters | removeunderscoresthatusedtobebetweenwords | Text |
| Encode | Encode as either HEX or Base64 | Text |
| Decode | Decode as either HEX or Base64 | Text |