Select to view content in your preferred language

eSearch export to csv format

3099
10
Jump to solution
08-18-2012 01:05 PM
JosephAccardi
Regular Contributor
Robert, I'm using your eSearch widget which is a great tool. I'm having some issues when I export out tables with cells that have long text strings (300-400 characters). The table that is exported has 5 fields, but whenever I do an export and open the csv file I notice that parts of the text in 3 of the fields are extracted and placed in a 6th field. Have you ever come across this? I can't find any direct correlation (i.e. after commas, after the 255th character, etc.).
Tags (2)
0 Kudos
10 Replies
RobertScheitlin__GISP
MVP Emeritus
Joe,

   Well that make a lot of scene now... When it come to a CSV fields are separated by a comma and if the text in that field contains a comma than the field value has to be wrapped in double quotes to signify that commas inside the double quotes need to be ignored but the introduction of a double quote inside the text throws all this off.

Be sure to mark your post as answered.
0 Kudos