Find bad data using File-Aid

The Easiest and Coolest way to locate bad data is thru File-Aid’s FIND command.

  • OPEN the file in FILE-AID (in either browse or edit mode).
  • Use FMT mode.
  • Then issue the below command.

F /field-name INVALID


F /field-number INVALID

The control will take you to the first invalid data record for the given field.

Example: The FILE has 3 fields namely NAME,AGE,COUNTRY. If you want to find the invalid data in the age field, then issue F /2 INVALID.

comments powered by Disqus