How to: Export Numeric or Currency Values
If you changed the Visual FoxPro decimal point character to a comma, numeric and currency data might be parsed into separate fields when you append or export the data. For example, Visual FoxPro would translate the value 100,000 into two fields because it appears to be delimited with a comma. Choose one of two methods to make sure the comma is properly translated:
Use tabs to separate fields in the text file
Change the decimal point character back to a period
If you want to export the text, use the COPY TO Command with the keywords DELIMITED WITH TAB.
If you want to change the decimal point character to a period before exporting text files, you can change the character back to a comma after you export the file.
To change the decimal point character
In the Command window, type the following command.
SET POINT TOExport the file using the DELIMITED keyword.
In the Command window, type the following command to reset the decimal point character to a comma.
SET POINT TO ','
See Also
Tasks
How to: Export Data to New Files
How to: Export a Quantity or Range of Records
How to: Export Records That Match Conditions
How to: Control the Record Export Process