To explain: I want to export a file containing a list of events, sorted
by date. These will be parsed into an InDesign Tags format for
importation into a weekly newspaper. The events will be displayed by
date, as in

Tuesday, July 19
1 p.m., event 1 information
3:30 p.m., event 2 information
7 p.m., event 3 information

Wednesday, July 20
10:30 a.m., event 1 information
1:30 p.m., event 2 information
6 p.m., event 3 information

And so on.

In the export, I need to export all of the relevant records in the date
range (that part's working), and have them be separated in the text
file whenever there's a date change. Using 'Summarize by' in FileMaker
only gives me the first record for each day ... I need all records,
broken by date.

bcrisler (AT) navix (DOT) net wrote:

There's no such thing as formatting the export. FM will always export all
of the specified fields for every record.

Create a global collecting field (text), then use loops to step through
each date and each event in each date, concatenating the desired info from
each to the end of that text field:

Set Field [g.Collector ; g.Collector & RecordField]

Then export just that one text field.

A similar effect could be achieved with a plugin (Troi File or Waves in
Motion FileTools), which would create of the text file and write to it,
line by line, but you would still have to loop through the records as
described, so that control is maintained over what goes to the file.

The first suggestion doesn't cost anything.

Matt