Serialize to CSV problem

Suite and Optimus Suite 5
#1

I have data loaded in a grid through XML. One of the columns is a name field, and occasionally someone has a comma in their name (i.e. Mr. Smith, Jr.). When I serialize the grid using serializeToCsv, this ends up being two separate columns. Can the serialize functions be modified to use the csv standard double-quote around each field? Or is there a way to serialize and specify the delimiter? I know there is a function to specify the csv delimiter for import, but is there a way to specify this for the serialize function?

#2

You can change CSV delimiter with setCSVDelimiter(str) method
http://docs.dhtmlx.com/doku.php?id=dhtmlxgrid:api_method_dhtmlxgridobject_setcsvdelimiter

#3

Thanks, that worked! I suggest updating the documentation for the setCSVDelimiter function and add the serializeToCSV function in the “See also” section. That would help people to know that this function also affects the serialize command.

#4

thank you for valuable feedback