Examples

Here are examples for record separators and record lengths.

Strip the first record that starts with $$ADD:

Record Separator \r\n
Max Record Length 100
Record filter
Count 1
Regular expression ^\$\$ADD.*$
Replacement

Change the record separator \u001e to \r\n

This change helps avoid the need to change the flat file definition and for archived files to be more readable.

Record Separator \u001e
Max Record Length 200
Record filter
Count
Regular expression \u001e$
Replacement \r\n

Strip all records that start with ISA or IEA:

Record Separator \r\n
Max Record Length 200
Record filter
Count
Regular expression

^ISA.*$

^IEA.*$

Replacement

Strip all records that are not 100 characters long, also remove "garbage" character at the end of the file:

Record Separator \r\n
Max Record Length
Record filter
Count
Regular expression

^.{0,99}\r\n$

^.{101,}\r\n$

^\W$

Replacement

Strip "garbage"

Remove garbage characters before the start tag, for example: "anytext=" and after the end tag to get a real XML file. This is not easy to make, however, here are possibilities:

Record Separator <
Max Record Length 200
Record filter ^.*=<$
Count 1
Regular expression ^[^>]*<$
Replacement <
Record filter ^.*[^<]$
Count 1
Regular expression >.*$
Replacement >