Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.
Trim Plus Transform
Transform Icon
Transform Description
The Trim Plus Transform allows the user to trim characters from the beginning and end of source data columns.
Option
Description
Input Column
The selected name of an input column where an action performs.
Choose Action
Action - The trim plus transform has six actions that can be used to trim characters from the source data.
Trim all leading and trailing white-space characters - This action trims all the spaces and tabs from the beginning and end of the selected columns data.
Trim all leading white-space characters - This action trims all the spaces and tabs from the beginning of the selected columns data.
Trim all trailing white-space characters - This action trims all the spaces and tabs from the end of the selected columns data.
Trim specified characters from start and end - This action trims all the specified characters in the Characters to be trimmed parameter from the beginning and end of the selected columns data.
Parameters
Characters to be trimmed - Specify characters that you want to trim form the start or end.
Trim specified characters from start - This action trims all the specified characters in the Characters to be trimmed parameter from the beginning of the selected columns data.
Parameters
Characters to be trimmed - Specify characters which you want to trim from the start or end.
Trim specified characters from end - This action trims all the specified characters in the Characters to be trimmed parameter from the end of the selected columns data.
Parameters
Characters to be trimmed - Specify characters which you want to trim from the start or end.
Output Action - There are two options for the output action.
Output Action - There are two options for the output action:
Replace the column data with fixed data - This option replaces the existing data with fixed data.
Output the fixed data to a new output column - The new output column name is inputcolumn_output, if the source column is FirstName the output column is FirstName_output.
