How to Remove dBASE Soft Carriage Returns from Memo Field

 Last reviewed: April 30, 1996
Article ID: Q113521
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, version 3.0
  • Microsoft FoxPro for MS-DOS, version 2.6
  • Microsoft FoxPro for Windows, version 2.6

SUMMARY

In FoxPro 2.6, the following dialog box will appear when FoxPro is opening a dBASE table: 

   Convert MEMO File to FoxPro Format?
      This can later be reversed with
         COPY ... TYPE FOXPLUS
           <Yes>            <No>
If you choose No, FoxPro will not open the database and the following error message will occur: 

   Not a table/DBF.
If you choose the Yes button, the following dialog box will appear: 

      Remove dBASE 'soft' carriage returns from MEMOS?
           Choose Yes if all memos are normal text
           Choose No if any memos have binary data
                  <Yes>               <No>
If you choose Yes, FoxPro will remove all soft carriage returns from all memo fields.

If you choose No, FoxPro will not remove any soft carriage returns.

MORE INFORMATION

When you are editing a memo field in dBASE, the autowrap feature of dBASE automatically inserts a soft carriage return when the line wraps. This soft carriage return has an ASCII value of 141.

Additional reference words: VFoxWin 3.00 FoxDos FoxWin 2.60 word wrap
wordwrap convert
import
export
KBCategory: kbprg
KBSubcategory: FxtoolGeneral

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.