次の方法で共有


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

  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

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

How to: Export Text Files

Concepts

Exporting Data