> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Transform

> Change column apparance

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

<Steps>
  <Step title="Select Column(s)">
    Select the column(s) you want to transform. You can choose multiple columns at the same time.
  </Step>

  <Step title="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                      |
  </Step>
</Steps>