Jef,

You want to use the Export Field Contents command, instead of the Export Records command. This will create a txt file, preserving carriage returns.

Regards,
Chad


On Apr 13, 2008, at 8:10 AM, jef chippewa wrote:

hi, i just moved to FMP8.5 from 7 (mac) and am exporting data as .txt files (tab-separated text) to be sent as an email attachment (one email/attachment per record). the data (composition programme notes) is contained in a single field for each record and has carriage returns that need to be retained (text to be edited by one person and translated by another).

this worked in v.7, but now the carriage returns appear as a strange character and the carriage returns aren't present anymore. they seem to be converted to line returns (shift-return; i checked in MS word); i can understand the reasoning for this (carriage return = next record in importing), but need to find a solution that works better for my needs in this situation.

a partial solution might be to export as ".doc" and run a replace script on the MS word doc before editing (prefer to edit in word anyways), then another on the final version to change carriage returns to line returns. but actually, i just tried to import a text with ONLY line returns (i.e. one paragraph), and filemaker interprets the line returns as carriage returns!

what to do?!

cheers,
jef



***************
Chad Novotny
Vice President - Technology
The Support Group, Inc.
database design, development and training services
boston - los angeles - new york - san francisco

24 Prime Park Way
Natick, MA 01760
t: 508.653.8400 x217
f: 508.653.2830
[EMAIL PROTECTED]
www.supportgroup.com

Reply via email to