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.*$
|
| 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 | 200 |
| Record filter | |
| Count | |
| Regular expression |
|
| Replacement |
Strip garbage characters
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 | > |