The following filters are provided in Systemwalker Runbook Automation Studio:
Uppercase and lowercase conversion
Row count
Append strings
Extract strings
Format
Delete duplicate rows
Replace
Extract rows
Sort
Delete rows
Delete spaces
Extract CSV data
Extract XML attributes
Convert date format
Operations
Point
Specifying input data for the filter:
If the input data is blank, the output result will be empty strings for the following filters:
Convert upper/lower case filter
Extract string filter
Format filter
Remove duplicate lines filter
Replace filter
Extract lines filter
Sort filter
Remove lines filter
Remove space filter
Extract XML attribute filter
If the input data is blank, an error will occur when executing the following filters:
Convert date format filter
Calculate filter
About display of whitespace characters
It is possible to display whitespace characters (half-width spaces, full-width spaces, tabs, and linefeeds) in each text field, just as with a normal text editor. (Excludes fields that only accept numeric input.)
Display example:
To enable/displayed display of whitespace characters, select Window >> General >> Settings >> Editor >> Text Editor.
Note
When executing filters that process row-by-row, the linefeed code in the output result is converted to LF (linefeed).
No linefeed code is attached to the end of the row if the filter execution results are output in a single row. A linefeed (LF) code will be attached to the end of each row when the filter execution results are output over multiple rows.
