Trim Plus

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.