Hi,
Running FM7 (update v.3) on a windows XP system.

I have a field that contains several lines of data :
Line 1
Line 2
Line 3
Etc

I want to export this data into a standard text file. (in a script)
I can't find a way to conserve the line breaks that are in the data field
in the final text file.

I have tried Export file ...
I have tried all the obvious output filetype options : tab, csv, ...
I have tried inserting the linebreak symbol with and without the \
backslash.

I have tried export Data to file
No luck there either.

In all cases, data comes out on one line whereas I want the text file to
look the same as the data field
Line 1
Line 2
Line 3
Etc

Any ideas ?
TIA

Don

Just discovered this
"Re: exporting ascii characters" posted here on 10/6
OK Harry, it's a helpful workaround but seems pretty weird that the pb
should exist in the first place.

Don




"Don Wimble" <Don.Wimble (AT) TennisElbow (DOT) com> a écrit dans le message de news:
42aea89a$0$1215$8fcfb975 (AT) news (DOT) wanadoo.fr...

In article <42aeb326$0$1236$8fcfb975 (AT) news (DOT) wanadoo.fr>, "Don Wimble"
<Don.Wimble (AT) TennisElbow (DOT) com> wrote:
FileMaker (and pretty much ANY similar application, including Access
and Excel) uses the return charater to separate records, so it can't
export that character. FileMaker itself will replace returns with
another character, which I can't recall at the moment. Some
applications allow you to redefine that delimiting character, but not
in FileMaker.

If you needing to do this regularly it can be a good idea to have a
second Calculation field that takes the original and replaces the
Return characters
ie.

ExportField {Calculation, Text result}
= Substitute (OriginalField, "¶", "*-*")

where the second parameter "¶" is the Return character. this field can
then be used for exporting instead. The "*-*" string can then be
replaced by the Return character again in the usual destination
applications (Word, PageMaker, etc.) or using a text editor application
if it is to remain as a plain text file.

The other way is to use a plug-in that has extra file handling routines.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Helpful Harry <helpful_harry (AT) nom (DOT) de.plume.com> wrote:

When I open the export file with AppleWorks, the character has vanished.

In earlier version of Word, you'll get a sort of line feed, which could
be searched (^z) and replaced by return characters (^a).
--
http://clk.ch

In article <1gy6tjm.gvmulub30ke8N%clk (AT) freesurf (DOT) ch>, clk (AT) freesurf (DOT) ch
(Christoph L. Kaufmann) wrote:

The character hasn't vanished. It's just not displayable and may not be
one of the ones AppleWorks knows about when "displaying invisibles".
Another reason why it's better to replace them yourself with something
visible like "*-*" before exporting the data. )

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)