Documentation forTask Factory

Task Factory Trim Plus Transform

 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
Task Factory Trim Plus Transform Icon The Trim Plus Transform allows the user to trim characters from the beginning and end of source data columns.

Task Factory Trim Plus Transform

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.
Additional Information:  See the Task Factory Error Row Handling article for more information about this functionality.