Hi

I am exporting the field contents of a calculated field. It has several returns in it.

If I open the resulting txt file in wordpad the formating is correct, however if I open it in Notepad it is formatted as one long string with no returns.

Is it possible to force this? If I open the txt file in wordpad and save over itself and reopen in Notepad it is fine.

The resulting file is required to be inserted as the body text of an email.

Any help would be greatly appreciated

Regards

ZP

If you don't have any Tabs in the export text:

After using the Export Field Contents step import back into a single field file. Export to a .txt file a second time and you have your file in the format you want.

when filemaker exports txt it saves it as unicode. That does not render right in notepad, but does in wordpad. You might just try inserting it into your e-mail(not sure how you are doing this), it may work.

Thanks for that.

I am using GWSend, which is a command line app for Groupwise to send email.

I have solved the problem by exporting the field via XML and using a stylesheet to insert a carriage return. See my post under XML/XSL forum (http://fmforums.com/forum/showtopic.php?tid/190533/post/268559/hl//fromsearch/1/#268559)

I will look at the export import option as well as it may be faster.

thanks again

ZP