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

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.

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

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.