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
--
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
