Filtering records

Where a file contains a mix of record types, records can be filtered for loading based on a given field not being empty or containing a given value or being within a size constraint. Any number of fields can be specified for filtering purposes. A record that does not match all of the filter criteria is skipped.

A filter on field size can require a field contain a specific number of characters or a minimum number of characters or a maximum number of characters.

By default, records are not filtered.

Filter criteria is specified using the ‘f’ and ‘F’ switches.

Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk