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 BLANK*

* Date and times separated by a space will be parsed as two fields with these keywords

To export to a text file

See Also

Other Resources