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