Microsoft KB Archive/305931

= INFO: DELIMITED WITH BLANK Behavior Differs in Various FoxPro Versions =

Article ID: 305931

Article Last Modified on 5/10/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition

-



This article was previously published under Q305931



SUMMARY
The behavior of the COPY TO ... DELIMITED command differs slightly in each version of Microsoft FoxPro and Visual FoxPro (VFP). You should be aware of these differences when moving code between versions.



MORE INFORMATION
The different versions of FoxPro produce slightly different text files using the same command. Depending on the version, leading spaces may be truncated or quotation marks may be added to character fields.

For example, COPY TO filename DELIMITED WITH BLANK in FoxPro 2.6a produces a text file that does not contain quotation marks around the character fields. If a character field contains leading spaces, they remain. Visual FoxPro 3.0, however, trims these leading spaces. Both these behaviors are contrary to the COPY TO documentation, which states in VFP 3.0:

DELIMITED Creates a delimited file. A delimited file is an ASCII text file in which each record ends with a carriage return and linefeed. The default field separator is a comma. Since character data may include commas, character fields are additionally delimited with double quotation marks.

DELIMITED WITH BLANK Creates a delimited file with fields separated by spaces instead of commas.

Visual FoxPro 5.0 and later behave correctly, including leading spaces and delimiting character fields with quotes. DELIMITED WITH &quot; &quot; removes the quotes, but replaces them with extra spaces.

In Visual FoxPro 5.0 and 6.0, attempts to remove the character field delimiter altogether fail in different ways. DELIMITED WITH &quot;&quot; and DELIMITED WITH [] give the following error:

Command contains unrecognized phrase/keyword.

DELIMITED WITH '' treats the first quote as a delimiter and ignores the second one.

However, Visual Foxpro 7.0 has been enhanced so that DELIMITED WITH &quot;&quot; does not give a syntax error. This allows you to create text files that have no quotes around any fields, which is desirable in some cases.

To observe these various behaviors, run the following code in FoxPro 2.6 or later. Feel free to experiment with the other forms of the command listed above. CREATE TABLE copyTest (cField1 C(30), cField2 C(10))

INSERT INTO copyTest VALUES (&quot;This is a test.&quot;, &quot;Part 1&quot;) INSERT INTO copyTest VALUES (&quot;    This is another test.&quot;, &quot;Part 2&quot;) INSERT INTO copyTest VALUES (&quot; This is a third test.&quot;, &quot;Part 3&quot;)

COPY TO copyTest.txt DELIMITED WITH BLANK

MODIFY FILE copyTest.txt

COPY TO copyTest.txt DELIMITED WITH &quot;&quot; MODIFY FILE copyTest.txt
 * 1) IF &quot;7.0&quot;$VERSION
 * 1) ENDIF

Keywords: kbinfo kbxbase KB305931

-

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

© Microsoft Corporation. All rights reserved.