December 17, 200223 yr Newbies 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.
December 18, 200223 yr 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
Create an account or sign in to comment