Split Filter Dialog Box

This filter splits the input string around specified single-character delimiters and generates RRT for each split parts.

Option Description
Field name Enter the field name of the FRTN generated by the filter.
Input Enter the input string to be split into parts. Commonly, RRT is used in this text box.
Delimiters Specify the single-character delimiters. The delimiters should be entered in this text box one after another without spaces; for example, ;|,. You can use RRT in this text box. If no delimiter is specified, then the result of splitting will consist of only one part that is a whole input string.
Match case If this check box is selected, then the comparison of the input string characters with the delimiter characters 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 the input is empty.

Result RRT:

~DFT::%field name, N%~ is replaced with the N-th part of the input string after splitting.

The examples of the filter usage:

Example 1

Input: ~ACC::UserName~_~ACC::%ClientID%.

Delimiters: 1

Match case: unselected

Assuming that ~ACC::UserName~ is replaced with "User1", and ~ACC::CompanyName~ is replaced with "Company1", the string will be split into three parts and the generated RRTs will be replaced with the following values:

  • User
  • _Company
  • empty string

Example 2

Input: 123abc456abc789.

Delimiters: aBc

Match case: selected

The string will be split into five parts and the generated RRTs will be replaced with the following values:

  • 123
  • b
  • 456
  • b
  • 789