Trim Filter dialog box
This filter removes all leading and trailing white space symbols from the input string.
| Option | Description |
|---|---|
| Field name | Enter the field name of the FRTN generated by the filter. |
| Input | Enter the string to be trimmed. Commonly, RRT is used in this text box. |
| Fail job if input/output is invalid | If this check box is selected, the component will reject the current job if either the input string or filter's result is empty |
This filter generates the following Boolean RRT that can be used in the Validate filter for metadata validation: ~DFT::%field name#IsEmpty%~. It is replaced with TRUE if a filter result is empty. Otherwise, it is replaced with FALSE.
Result RRT:
~DFT::%field name%~is replaced with the string after trimming.