Re: Text File Output

In article <290320081208125632%helpful_harry@nom.de.plume.com>, Helpful
Harry wrote:

> In article
> <7b3d5f79-0901-41c1-945e-5d713a21594b@d4g2000prg.googlegroups.com>,
> JayBee wrote:
> >
> > Hiya
> >
> > I have tried manual line break and it seems to take the quotation mark
> > from the calculaiton field on to the next line so you end up with a
> > field not entirely enclosed in quotation marks. I'll try the paragraph
> > mark and see if it makes any difference.
>
> Sorry, that's a hiccup I hadn't seen.
>
> By replacing *-* with /l or /p, it simply moves the last " down to the
> next line. D'oh!
>
> Instead, replace *-*" with "/l or "/p (Note the single " are important
> in both the Find and Replace options). This will put a new " on the end
> to complete the field, and THEN insert the line / paragraph break to
> complete the record.

Another problem you may run into is completely blank records in the
final export file after post-processing in Word. The easiest way to get
rid of these is to do another Find for double returns and Replace them
with a single one.
eg.
Find /p/p Replace with /p

You may need to run this two or three times to get rid of them all,
depending on how many blank 'sub-records' there are in your original
FileMaker database. It also means you may have to use /p instead of /l.

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