I've got an older DB in FMP6 that I need to export some data from. Whenever I export as a CSV, the file contains double quotes around my data fields. The program I need to feed this data

to can't interpret the quotes.

Here's one record as it is exported:

"000011015","ACT","COM","11/11/2006","29","11","3/14/2007","3/14/2007","1","A08421","P000011015"

I need:

000011015,ACT,COM,11/11/2006,29,11,3/14/2007,3/14/2007,1,A08421,P000011015

Of course I can do this manually, but that's silly. Anyone know how to export a CSV out of FMP6 without the quotes?

You can use Export XML, with an xsl stylesheet. It is a generic one that will work with any FileMaker file.

<?xml version='1.0' encoding='utf-8'?>



exclude-result-prefixes="fmp" version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">



	

		

		

			

			

			

					

					

						

							,

						

						

							

						

						

						

					

								

		

		

	

[P.S. Those are Windows PC line endings. For more generic Unix line endings, use just the 
  lose the 
 ] 

Edited March 20, 200718 yr by Guest