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.).
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.
Thanks Robert. Like I said, the csv export generated an additional column and populated it with text from 3 other columns. I attached the export called "Selected Records.csv" and the way it should look called "Correct Format.xls". Thanks for your help.
So the tab delimited looks correct so it has something to do with the CSV format... Which datagrid are you exporting from the fixed or float? Does the data look correct in the datagrid before export?
I'm using the float datagrid. The results in the datagrid table look perfect. I attached the section of my XML code that pertains to the datagrid and a snapshot of what the datagrid looks like before I export it...
Robert, I removed the " character from my cells and replaced it with the word 'inch' and everything works now. Not sure why this was whacking it out, but I'm good on my end. As always thanks for all your help.