FIX: COPY TO DELIMITED Creates File with No Carriage Returns

ID: Q110539

2.50b MACINTOSH

kbusage   kbtshoot

 The information in this article applies to:

  - Microsoft FoxPro for Macintosh, version 2.5b

SYMPTOMS

In FoxPro for Windows and FoxPro for MS-DOS, the following commands create a delimited ASCII file, with each record terminated by a carriage return and linefeed (CR/LF) combination. In FoxPro for Macintosh, the same commands create a delimited ASCII file, with each record terminated by a linefeed only.

   USE customer
   COPY TO newfile TYPE DELIMITED

Many programs, such as Microsoft Word for Macintosh, require that delimited records be terminated by a carriage return at the end of each record. This problem occurs regardless of the delimiter used; for example, the problem occurs whether the DELIMITED or DELIMITED WITH TAB clause is used.

RESOLUTION

There are two possible workarounds for this problem:

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in FoxPro 2.6a for Macintosh.

Additional reference words: FoxMac 2.50b fixlist2.60a buglist2.50b line feed hard return soft return tshoot trouble-shoot

KBCategory: kbusage   kbtshoot
KBSubcategory:
Keywords          : kbcode kbtshoot kbusage
Version           : 2.50b
Platform          : MACINTOSH
Solution Type     : kbfix

Last Reviewed: May 21, 1998