Microsoft KB Archive/115109

= INFO: @ Cannot Be Used As a Delimiter with the APPEND Command =

Article ID: 115109

Article Last Modified on 2/11/2005

-

APPLIES TO


 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.6 Standard Edition
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.6 for MS-DOS
 * Microsoft FoxPro 2.5b for Macintosh
 * Microsoft Visual FoxPro 2.5c for Macintosh
 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q115109



SUMMARY
The at sign ("@") cannot be used as a delimiter in FoxPro versions 2.5 and 2.6 for MS-DOS and Windows when you are using the APPEND command to append information from an ASCII text file.



MORE INFORMATION
A number of UNIX-based products such as EMPRESS generate ASCII files using @ signs as delimiters. The following is an example of an ASCII file generated by EMPRESS version 6.0 running on a Sun Microsystems SPARC workstation:

  704@575@1111@JOHN B SMITH 704@575@1122@FRANKLIN T WOND 704@575@1133@ALICIA J ZELAYA

However, when you use @ as a delimiter with the APPEND command, as in the following example

  APPEND FROM  DELIMITED WITH @

(where the  is the name of the ASCII file), FoxPro will not recognize the @ sign as a delimiter and will try to include each record from the ASCII file in the first field of the FoxPro .DBF file.

To correct this problem:


 * 1) In the Command window, type the following to open the text file: MODIFY FILE 
 * 2) From the Edit menu, choose Find.
 * 3) Type "@" (without the quotation marks) in the Look For text box, and type "," (without the quotation marks) in the Replace With text box. Then choose Replace All.
 * 4) Save the file, and then use the following APPEND statement: APPEND FROM  DELIMITED WITH ,

Additional query words: FoxMac FoxDos FoxWin

Keywords: kbinfo KB115109

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.