Exporting Records That Match Conditions

  • Article

If the records you want to export are not sequential within the table, you can build a logical expression that specifies the selection criteria a record must meet to be exported. For example, you can choose to export all records with a particular value in a field.

To enter criteria for exporting records

  1. From the File menu, choose Export.

  2. Enter the source table and destination file information.

  3. Choose Options.

  4. Choose For to build an expression in the Expression Builder dialog box.

    Note   You do not need to include the FOR command in the expression. For example, type customer.country = "Canada" to export only Canadian data.

  5. Choose OK.

    Visual FoxPro evaluates all of the records and exports those that match the condition in the expression.

See Also

Exporting a Quantity or Range of Records | Controlling the Record Export Process | Importing and Exporting Data | Exporting Text Files | Exporting Numeric or Currency Values | The Process of Exporting Data