Exporting Numeric or Currency Values

  • Article

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

  1. In the Command window, type the following command.

    SET POINT TO

  2. Export the file using the DELIMITED keyword.

  3. In the Command window, type the following command to reset the decimal point character to a comma.

    SET POINT TO ','

See Also

Exporting Text Files | Controlling the Record Export Process | Importing and Exporting Data | Exporting Records That Match a Condition | Exporting a Quantity or Range of Records | The Process of Exporting Data