Strip / Replacement

You can define one or more Strip/Replacement steps that will be applied to every record in the defined order. The output from one step is the input to the next step. After the last step, the record is written to the output file.

Record Filter

The property Record filter expression is used to specify a record filter. If a regular expression is given the complete record, including the record separator, must match the regular expression. Otherwise, the record will not be processed by this step. Note that the dotall mode is used: the expression "." matches any character including a line terminator. Use a blank value for no record filter.

Record max

The property Record max count to replace is used to limit the number of records to be processed by this step. For example: if you type the value 1, this step will be applied to max one record. Use a blank value for no limit.

Regular expression

The property Regular expression contains a regular expression for the substrings to be replaced in the record. The regular expression does not need to match the complete record. This property is mandatory.

Replacement string

The property Replacement string contains the replacement string that will replace each substring in the record that matches the given regular expression. Remember that the resulting record, normally, must end with a record separator. You can use escape sequences for string literals in the same way as when you hard code a string in Java.

For more information about string literals, see String Literals.

If the regular expression matches the complete record, including the record separator, and an empty replacement string is given, this means that the record is removed or "stripped".