exporting quotation marks

[Jalz]

Hello Guys,

Im writing an csv export, so an accounts package will eventually import the data in. I have the CSV format the accounts package requires. Ive been mapping the fields from my app to this, and I've created a couple of calculated fields with a number of commas in. When I run the export the field that I have created which contains lots of commas in has quotations going around the first comma and the last comma. What I need is quotations going around all the comma's.

My current stored text calculation for field comma5 is

",,,,,"

Output in csv is ",,,,,"

Output I would like to achieve is ",",",",","

Many Thanks

Jalz

[comment]

The CSV format uses commas and quotation marks to separate between fields. It sounds like you are trying to fool the system into exporting more "fields" than you actually have.

[Jalz]

Yes, thats exactly what I am trying to do without having to recreate unnecessary empty fields.

[comment]

Yeah, well, the problem is the system was designed NOT to be fooled by anything it may find inside a field. I haven't tested this, but you might get around by calculating the entire CSV row, then exporting only this field in a tab-separated format.