Exporting Text Files
If you export to a text file, Visual FoxPro assumes that your fields are separated by commas and that each character field is enclosed by quotation marks. If you have set the decimal point character to display as a comma, numeric and currency data might be parsed into separate fields.
To export to a text file, use the COPY TO command with the appropriate DELIMITED clause as shown in the following table:
| For these separators | Use this DELIMITED clause |
|---|---|
| Commas between fields and quotation marks enclosing character fields | DELIMITED |
| Character fields enclosed by a character other than quotation marks | DELIMITED WITH delimiter |
| Tabs between fields | DELIMITED WITH TAB |
| Spaces between the fields | DELIMITED WITH BLANK1 |
1 Date and times separated by a space will be parsed as two fields with these keywords
See Also
Controlling the Record Export Process | Importing and Exporting Data | Exporting Numeric or Currency Values | Exporting Records That Match a Condition | Exporting a Quantity or Range of Records | The Process of Exporting Data