In FM 10, the following has the potential of generating a text file from a found group of records with a single header and footer if needed:
Use a global text field, a loop script and the "char" functions to build the export file inside a single global field. I took the precaution of adding a second return between these internal "records".
Then find a single database record, then...
Observed the following:
Copy-pasting the field contents to Word, the tabs, line feeds & returns are all preserved.
Exporting the field as tab-separated changes the tabs to spaces and changes returns to line feeds.
Exporting it as comma-separated keeps the tabs and changes returns to line feeds. Comma-sep has only a single leading and trailing quote mark to remove.
--
Steve Gerow
FileMaker 9/8/7 Certified Developer
President
Abrazos Data Consulting, Inc.
Pasadena, California
Member FileMaker Bus. Alliance
> -------Original Message-------
> From: Marina Tadiello <
[hidden email]>
> Subject: Adding a header to exported records
> Sent: Oct 14 '09 22:47
>
> My "handmade" solution is to add a record with the contents of
> the header to the database, and give it a sort order lower than
> any other record - so that if you sort your records before
> exporting, the record with the contents of the header appears as
> the first.
>
> Alternatively, you could add a row with the header contents
> after importing the exported records into your new list (eg a
> spreadsheet file, which can then be exported into any word
> processing file).
>
> marina
>
>
> >I'm exporting the contents of a FMP field to create a list of names
> >and addresses. I need to add a header to the exported file but
> >it only
> >appears once at the top of the exported file and not before each
> >exported record. How would I go about achieving that?
>
