Jump to content

quote marks


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

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4728 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
×
×
  • Create New...

Important Information

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