Inserting blank records

[david preswick]

I need to import records created in filemaker to an accounting program
(MYOB).

It can only recognise different records if there is a blank in between. I
can make a blank every second record easily enough
but need the blank after each occurrence of a different number.

see following 7 records

555
555
556
557
557
558
559

They must be as follows
555
555

556

557
557

558

559

The blanks are just empty records. Any ideas ... thanks David

[No Spam]

In article <tUh2b.69$EF.4577@nnrp1.ozemail.com.au>, david asked:

> I need to import records created in filemaker to an accounting program
> (MYOB).
>
> It can only recognise different records if there is a blank in between. I
> can make a blank every second record easily enough
> but need the blank after each occurrence of a different number.

If you want to export occasional blank records, you will need to create
them. You could do so in a FileMaker loop that just counted and
compared. It would probably be better to create a new database which
you would eventually delete, rather than worry about extracting the
additions.

The simplest approach would be to post-process the exported records
with a trivial script which would insert the blank lines. This could be
Applescript called from FileMaker.