【黄啊码】如何将制表符分隔的文件转换为CSV

 $ echo "hello world" | tr "\t" "," hello,world 

 import sys import csv tabin = csv.reader(sys.stdin, dialect=csv.excel_tab) commaout = csv.writer(sys.stdout, dialect=csv.excel) for row in tabin: commaout.writerow(row) 

 python script.py < input.tsv > output.csv 

 perl -lpe 's/"/""/g; s/^|$/"/g; s/\t/","/g' < input.tab > output.csv 

 sed -e 's/"/\"/g' -e 's/<tab>/","/g' -e 's/^/"/' -e 's/$/"/' infile > outfile 

 import sys import csv pipein = csv.reader(sys.stdin, delimiter='|') commaout = csv.writer(sys.stdout, dialect=csv.excel) for row in pipein: commaout.writerow(row) 

 # cat file header header header one two three $ awk 'NR>1{$1=$1}1' OFS="," file header header header one,two,three 

 awk 'NR>1{gsub("\t",",")}1' file 

 sed '2,$y/\t/,/' file #skip 1 line header and translate (same as tr) 

 printf "flop\tflap"" | awk -F '\t' '{ gsub(/"/,""""",$i); for(i = 1; i <= NF; i++) { printf ""%s"",$i; if( i < NF ) printf "," }; printf "\n" }' 

 "flop","flap""""