Re: vim: what the current best practice to work with excel file (xlsx)?

hi Tom:
yes I did some research, very funny that the method to define a new delimiter when exporting data from EXCEL is outside of the App:
http://www.howtogeek.com/howto/21456/export-or-save-excel-files-with-pipe-or-other-delimiters-instead-of-commas/

since I'm running crossover (wine emulation) MS excel, it doesn't work for me.

b.t.w I meant OO *CAN" opent the MS files without issues in most time.

On 06/08/2012 12:46 PM, lith wrote:

        csv (comma delimited)                 some of my data contains          comma  

  If your method of changing the field separator doesn't work, as a last resort you could also change the locale (some use ; as field separator). Or, the proper solution, you could enclose the field in quotes (you'd probably have to research the proper escaping rules).    It's odd that OO or LibreOffice cannot open the file. Can you import the file into google docs?    Regards,  Tom