CSV export missing quotes
This is one of those crazy bugs you don't know about until it happens. I have a view with a field that has sentences between brackets [], and each has a new line \nl after it once it was created. When I export this view as a CSV private link, all the records put quotes "" around the text in this field. However, the record that does not have a comma , or semi-colon ; in it does not get a quote. This wreaks havoc on Zoho sheets, when trying to link a CVS - it does not come in correctly or sometimes does not come in at all.
Is there a way to make Zoho place quotes in all records that have a bracket in them when exporting to CVS no matter if it has a comma or not? Maybe place quotes on all records that have a new line \nl?
To see this in action, i have given you view permission. Look at the view- Building Metrics Table, and export to cvs private link, and look at the second record, under the field Open Request List. You will notice all records have quotes except the 2nd record.
thanks for your help!