How do convert TSV file to CSV format using openoffice ?
A:
TSV = Tab separated ?
If so, just give it a .txt extension, open in the spreadsheet program (Calc) as CSV, the Wizard will ask you which is the field separator, choose TAB. Afterwards, save it as a (true) CSV.
leonbloy
2010-03-31 01:20:16
Ya I tried same. It again saves it as tab separated file with CSV extension
Kurund Jalmi
2010-03-31 18:33:51
http://www.oooforum.org/forum/viewtopic.phtml?t=65981 it worked for me, though
leonbloy
2010-03-31 19:03:03
It works for me. Using Calc 3.1.1 here.To save, I select "Save as", choose "Text CVS " , and (just to be sure) check the option "Edit filter settings". In that way you can verify-force, in the next dialog, that the the comma is used as separator for the new file.
leonbloy
2010-04-01 01:05:38
A:
Only solution that I found was find and replace, I used my emacs to replace "tab" with "," and it worked.
Kurund Jalmi
2010-03-31 18:34:46
this would be error prone, in the case the fields have commas inside them
leonbloy
2010-04-01 00:54:24