Task Factory Trim Plus Transform

Trim Plus Transform 

Transform IconTransform Description
Task Factory Trim Plus Transform IconThe Trim Plus Transform allows the user to trim characters from the beginning and end of source data columns.

Task Factory Trim Plus Transform

OptionDescription
Input ColumnThe selected name of an input column where an action performs.
Choose ActionAction - 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.

Additional Information:  See the Task Factory Error Row Handling article for more information about this functionality.