Export to csv without the quotes

[comment]

I'd like to know the answer to this too. My tests so far show that the XSLT processor in version 10 is the same one as in all the previous versions.

[Joost Miltenburg]

Is this bug only related to repeating fields ? I have this problem with normal records with no repeating fields.

Does the 'workaround' also apply to normal records with normal fiels where I just add a CRLF at the end of a record ?

TIA

[comment]

I am not on Windows, so I don't really know. I think it affects calculation fields where the formula contains "&¶" and perhaps also text fields that contain a carriage return.

[MaxB.]

The attached XSL file, when used in an XML Export, will strip the quotes. It does data only, no header, no field names. If you need those then you need to tell us. As Vaughan says, if you've got commas in the data, you're pretty much screwed if you strip out the quotes. Do they support tab-delimited? Likely not; they sound pretty clunky.

(P.S. It's for a FMPXMLRESULT grammar export.)

 

Sorry to bump an old thread, but the XSL file attached is almost exactly what I am looking for. The only thing is I also need the first record to be field names. I don't know anything about XML/XSL so I have no idea how to change this myself.

[comment]

The only thing is I also need the first record to be field names.

 

See if this helps:

http://fmforums.com/forum/topic/48901-exporting-to-a-csv/?p=228807