Convert-to from csv to ods and viceversa [closed]
I have this problem. A ".csv" file where delimiter is tab and content is a "Little-endian UTF-16 Unicode text" If i try to open it with gui in libreoffice my true settings are
Charset: Unicode Language: Default - English (USA) From row: 1 Separated by: tab, comma
via shel i'm trying
unoconv -f ods -e FilterOptions="59/44,34,UNICODE,1" [FILE]
but the result is a file with wrong separation. What's wrong?
And what's is the best shell command in order to convert this ods to file to a well generated csv (Unicode UTF8, comma separated, ecc.)?
I have tried to use LibreOffice from the Command line to convert from CSV file to Excel.While the software works great while using the GUI; it does not recognise Unicode characters, or semicolon delimited fields, and the output is only one chunk of data ( one column). How should I write my comenad line to let LibreOffice know I am using ";" as delimiter in a Unicode CSV file ? My command is: "C:\Program Files\LibreOffice 4\program\soffice.exe" --headless --convert-to xls --outdir "C:\DBA\scripts\CSV-to-Excel" "C:\DBA\scripts\CSV-to-Excel\CSV_file.csv" The output leaves a blank row in between two rows, and does not properly respect Unicode characters. The data ins left in only one column
59/44
stand for separated by;
or,
try with9
insteadWith unoconv -f ods -e FilterOptions="9,34,UNICODE,1" is the same
FYI: I merged a question re saving as xls from csv to this one, so don't be suprised that some of the answeres refer to Excel export filter :-)