how can I conert a excel file to csv quoted text ?
Posted on 2014-10-30
I need to get to the data in an excel spreadsheet. I have tried excel to csv however there are line feeds (hex 20 ) within many of the cells.
I tried some free macros that seemed to quote the data however rather than getting "quote me" , I would get """quote me""".
After trying to modify the script by reducing the quotes, the script started doing very strange things and did not like my Linux fingers on it ..... :)
can I convert excel to csv with quotes ?