Re: Exporting to quark express

[gcottle]

I am new to filemaker. I'm trying to export a recipe database and need some help. I need to find a way to add quark style tags prior to the data from each field, and then add a paragraph mark at the end of field. Like this:

@styletag[fielddata][return]

So that a typical recipe might look like this:

@recipetitle[Cinnamon Muffins][return]

@author[Mary Stiles][return]

@ingredients[1 cup shortening][return]

Does anyone know how to do this? Even if I could only export a single unique character in place of the style tags this would at least allow a successful find and replace in a word processor.

Also, I need to find something similar that lets me insert a unique character, or paragraph mark between data exported in a repeating field. I put the ingredients into a repeating field and when they export now, they come out as one long string. Nasty, with 1200+ recipes. Any ideas?

You can email me at [email protected] if you need further clarification.

[jasonwood]

Sounds like you probably just need a calculation field...

The only problem is that the paragraph symbol is used in calculations for a carriage return, so I'm not sure if you can export the symbol itself. Like you said, you can do a replace, so I'll do my example with a %.

if you have fields recipetitle, author, and ingredients that you want to export in the above format, the calculation would look something like this...

"@recipetitle[" & recipletitle & "]%" &

"@author[" & author & "]%" &

"@ingredients[" & ingredients & "]%"

Then just export that field

[gcottle]

Thanks. That did it.