Friday, June 8, 2012

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

> 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

--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

No comments: