Transform - Less Documentation

The Transform tool is a multi-purpose tool that can be used to change both text and numeric columns. Its purpose is to format the given column into a certain shape, such as making a text column UPPERCASE or rounding a decimal columns to 2 decimals.

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

Tools

​Configuration

Configuration