Importare da excel a file testo: File -> Salva con nome -> Formato csv (file.xlsx -> file.csv)
sed 's/,/./g' file.csv sed 's/;/ /g' file.csv sed $'1s/\xef\xbb\xbf//' file.csv
Script di conversione: #!/bin/csh cat $1 printf "\n" echo "new line" printf "\n" sed 's/,/./g' $1 > out1.csv cat out1.csv printf "\n" echo "new line" printf "\n" sed 's/;/ /g' out1.csv > out2.csv cat out2.csv printf "\n" echo "new line" printf "\n" sed '1s/\xef\xbb\xbf//' out2.csv > new.csv cat new.csv rm out1.csv rm out2.csv