JavaScript Editor js editor     Web development 

Main Page

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


    Character fields enclosed by a character other than quotation marks

    DELIMITED WITH delimiter

    Tabs between fields


    Spaces between the fields


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

See Also

JavaScript Editor js editor     Web development