How to change the separator character on a Grid with a CSV Source?
By default the separator character is the " , but i need to change it to the ' , because of my automatically generated CSV file. Excel or StarOffice Calculation Sheet allows to change the caracter, can you ppl help me out doing it using active widgets?
Tuesday, February 12, 2008
There is no such option in the API - you have to modify the source code. Go to the /source/lib/csv/table.js and replace " with ' in lines 85,86,88 (variables x1, x2, s2).