Export text with a header

[ibiubu]

How to add a header to an exported text document

1) I am exporting about 10 records or so to a text Document. I need a particular text string that always stays the same to be the very first item in the text document. Is there any way to get filemaker to insert the text string at the first of the text file as it exports. The string never changes. I know I could create a field in filemaker and enter the text string in only the first record and not the rest of the records, but just wanted to know if there was a more elegant way.

LR

[ March 24, 2002, 08:49 PM: Message edited by: Larry Ross ]

[ibiubu]

Actually, I figured out the answer.

I have a text field in each record called "bodycopy" that when the database is exported as a text file, this particular field is always the first item of each record exported.

I added 2 calculation fields to each record:

1) Status(CurrentRecordNumber)

2) If(Number = 1, "headertexthere", "") & bodycopy

What this did was copy my text from my "bodycopy" field and at the same time looked at the field "Number" on each record, and on the record with a "1" in this field it added "headertexthere" to the front of my bodycopy.

Now when I export the database to my text document, the text document starts off with my header text string that I wanted.

LR

[ March 24, 2002, 09:05 PM: Message edited by: Larry Ross ]