Transform

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