• 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.