Trim Plus

Parent Previous Next


Trim Plus Transform


The "Trim Plus Transform" allows the user to trim characters from the beginning and end of source data columns.



  Input Column - The name of the input column that will have an action performed on

  Choose Action

o   Action - The trim plus transform has 6 actions that can be used to trim characters from the source data.

 Trim all leading and trailing white-space characters - This action will trim all the spaces and tabs from the beginning and end of the selected columns data.

 Trim all leading white-space characters - This action will trim all the spaces and tabs form the beginning of the selected columns data.

 Trim all trailing white-space characters - This action will trim all the spaces and tabs from the end of the selected columns data.

 Trim specified characters from start and end - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the beginning and end of the selected columns data.

 Parameters

o  Characters to be trimmed - Specify characters which you want to trim form the start or end.

 Trim specified characters from start - This action will trim all the specified characters in the "Characters to be trimmed" parameter form the beginning of the selected columns data.

  Parameters

o   Characters to be trimmed - Specify characters which you want to trim form the start or end.

 Trim specified characters from end - This action will trim all the specified characters in the "Characters to be trimmed" parameter form the end of the selected columns data.

  Parameters

o   Characters to be trimmed - Specify characters which you want to trim form the start or end.

o  Output Action - There are two options for the output action

 Replace the column data with fixed data - This option will replace the existing data with fixed data

 Output the fixed data to a new output column - The new output column name will be "inputcolumn_output", for example if the source column is "FirstName" the output column will be "FirstName_output"


Please see the Error Row Handling page for more information about this functionality.