Re: Converting Memo Field Carriage returns

You need to figure out what is being used for "returns" in the Memo field. I would assume you are using Access. I'm not positive what Access uses for returns in Memo fields, but a vertical tab (ascii 11) or form feed (ascii 12) are pretty commonly used. If you export your database as tab/return delimited, you may be able to figure out what characters are used inside memo fields for tabs and returns. It shouldn't export embedded tabs and returns as tabs and returns since that would screw up the export format. I'm basing this info on how FileMaker handles "Memo" fields. On Friday, May 2, 2003, at 06:36 AM, Roy W wrote:

Can someone tell me how to convert Memo field entries carriage returns to: "\n" type entries so that formatting is retained when I retrieve it from a MySQL database and post it to an email -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577