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