How to: Export Numeric or Currency Values

JavaScript Editor js editor     Web development 



Main Page

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:

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.

    В Copy Code
    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.

    В Copy Code
    SET POINT TO ','

See Also



JavaScript Editor js editor     Web development