Convertion XLS to CSV data format issue
by satyarankireddy from LinuxQuestions.org on (#4TMGY)
Hello Team,
I have converted .xls files to .csv format using uniconv option in Linux. I have noticed that number columns values are changed comma (,) to dot (.).
Command:-
for input in /test/test_file.xls; do
unoconv -f csv -e FilterOptions="59,0,0,0" --stdout $input | tail -n +6
done > /test/model.csv
Input file data (.XLS)
50,234,00
83,3
72,2
After conversion (.CSV)
50.234.00
83.3
72.2
My worry here, I want to convert data as it is form .xls to .csv. Does it possible using the above command?
Note: Column separator as ; (Semi-colon). Everything is working fine except this value issue.
I have converted .xls files to .csv format using uniconv option in Linux. I have noticed that number columns values are changed comma (,) to dot (.).
Command:-
for input in /test/test_file.xls; do
unoconv -f csv -e FilterOptions="59,0,0,0" --stdout $input | tail -n +6
done > /test/model.csv
Input file data (.XLS)
50,234,00
83,3
72,2
After conversion (.CSV)
50.234.00
83.3
72.2
My worry here, I want to convert data as it is form .xls to .csv. Does it possible using the above command?
Note: Column separator as ; (Semi-colon). Everything is working fine except this value issue.