Skip to main content

Trim Transformation

To strip leading and trailing spaces from the text in one or more cells, you can use the Trim Transformation. This transformation removes all spaces from a string of text except for single spaces between words.

Steps to Apply Trim Transformation​

This guide will give you a brief idea of what steps you need to follow to apply Trim Transformation in a queried data.

Step 1: Add Transformation Type​

First, visit the Add Transformation page to add the To Trim Transformation

Step 2: Select Source Column​

Click the Source Column dropdown to select the column on which you want to apply transformation.

Select

Use Advanced Option​

  • When you click on the Advanced options down arrow you will be asked whether you want to save the desired output in the same source column or want to create a new column.
Advanced
  • By default, your output will get saved in the same column, click on the Create a new column to return the result in a new column.
Create New

Step 3: Save Transformation Configuration​

Click the Save button to save the Transformation configuration.

Save Transformation

Add Another Transformation​

After defining the first Transformation, you can add multiple transformations to the defined Transformation or add another new Transformation step to a bot This flexibility helps you to get the desired output in one go.

Step 4: Save & Test​

Once you have done with the above-mentioned steps, click the Save & Test to test and save the Transformation.

Save & Test

Any Question? 🤓​

We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io