I need to output a text file in a format that looks like:

"","name","email","1","0",""

where all the quote marks, as above, are required in the output and the names, emails and flags are pulled from an xls file into the database with appropriately named fields. I have an export field that joins the whole lot together. I ran into a lot of problems with escaping quotes and have achieved a result by using a bullet character for the quotes and, as the last step in a script, find/replace all the bullets with quotes.

Although it works, it seems a bit clunky. What do you reckon?

cheers

Roger

This is standard CSV export format. It'd be simpler just to export the separate fields and let FMP do the heavy lifting.

However if you want to continue, export your "export" field as Tab delimited. Forget the mucking around with bullets etc, just put the quotes in the calc field.