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