Strip columns

The Strip columns transformer allows user strip values in a column by choosing which part of the row needs to be stripped and the value to be stripped.

Strip Spaces Transform dialog is shown as below:

1. Enter Title for this transform step. Ensure that the Title is uniquely identifying the step
2. Optionally, Enter Description to provide further information for this particular step. This is helpful in ensuring readability of the step in a large workflow.
3. Click on the plus icon to create a new column record to strip
4. Select the Column. where strip transform needs to be performed
5. Click on how to select type of strip to be performed. Select from one of the following options.
6. Click Create to add the step to the recipe.

Supported formats are :

1. Leading Values : Strip when the value is leading character in the string.
2. Trailing values : Strip when the value is trailing character in the string
3. Both : Strip if value is either leading character or trailing character