awk_tips

awk输出大小写引号

echo aa | awk '{print "'\''"$0"\""}'

'\'' 单引号
\" 双引号

行列转换

#行转列
awk -F"+" '{for(i=1;i<=NF;i++) a[i,NR]=$i} END {for(i=1;i<=NF;i++){for(j=1;j<=NR;j++)print a[i,j] "";print ""}}' file.txt

awk 'BEGIN{i=1}{gsub(/#/,"\t"i"\n");i++;print}' uids|sed '/^$/d' > uids_seg

#列转行
cat file.txt | tr "\n" "," | sed -e 's/,$/\n/'