Change column apparance
Select Column(s)
Select Transformation
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 | Text | |
HTML to Text | Text |