Contains Filter dialog box

This filter checks if the input string contains a specified substring.

Option Description
Field name Enter the field name of the FRTN generated by the filter.
Input Enter a string to be tested for containing a specified substring.
Contains Enter the substring that will be looked for in the input string.
The filter generates an error if Contains parameter is an empty string.
Match case If this check box is selected, then the comparison is case-sensitive. Otherwise it is case-insensitive.
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.
Result This group of settings specifies the value of the generated RRT.
On success Specify a value for replacement of the generated RRT in case the input string contains the specified value. You can select a value from the predefined alternatives (TRUE, YES, ON, 1) from the drop-down list or enter any other value manually. The default value is TRUE.
On failure Specify a value for replacement of the generated RRT in case the input string does not contain the specified value. You can select one from the predefined alternatives (FALSE, NO, OFF, 0 ) from the drop-down list or enter any other value manually. The default value is FALSE.

Result RRT:

~DFT::%field name%~ is replaced with the value configured as a success result if the input string contains the specified substring and with the value configured as a failure result otherwise.

This filter generates the following Boolean RRTs, which can be used in the Validate filter for metadata validation:

  • ~DFT::%field name#IsSuccess%~ is replaced with TRUE if the filter operation ends with success. Otherwise, it is replaced with FALSE.
  • ~DFT::%field name#IsFailure%~ is replaced with TRUE if the filter operation ends with failure. Otherwise, it is replaced with FALSE.

The example of the filter usage:

Input: Is there the digit two (2) in this string?

Contains: 2

Match case: unselected

On Success: TRUE

On Failure: FALSE

The generated RRT will be replaced with: TRUE.