Jump to content

Export text with a header


ibiubu
 Share

This topic is 7072 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 ]

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 7072 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.