001、 利用循环语句实现
[root@PC1 test]# ls a.txt [root@PC1 test]# cat a.txt pbh003 ERR12389589 ERR12389588 ERR12389587 ERR12389586 ulu010 ERR12389614 ERR12389613 sub008 ERR12389591 ERR12389590 tpc003 ERR12389593 ERR12389592 bad003 ERR12389576 ERR12389575 [root@PC1 test]# awk '{print $1}' a.txt | while read i; do grep "^${i}[[:space:]]" a.txt | cut -f 2- | sed 's/\t/\n/g' | awk -v a=$i '{print a,$0}'; done ## 按照第一列的行名展开数据 pbh003 ERR12389589 pbh003 ERR12389588 pbh003 ERR12389587 pbh003 ERR12389586 ulu010 ERR12389614 ulu010 ERR12389613 sub008 ERR12389591 sub008 ERR12389590 tpc003 ERR12389593 tpc003 ERR12389592 bad003 ERR12389576 bad003 ERR12389575
002、
[root@PC1 test]# ls a.txt [root@PC1 test]# cat a.txt pbh003 ERR12389589 ERR12389588 ERR12389587 ERR12389586 ulu010 ERR12389614 ERR12389613 sub008 ERR12389591 ERR12389590 tpc003 ERR12389593 ERR12389592 bad003 ERR12389576 ERR12389575 [root@PC1 test]# awk '{for(i=2; i<=NF; i++){print $1,$i}}' a.txt ## 利用awk内循环展开数据 pbh003 ERR12389589 pbh003 ERR12389588 pbh003 ERR12389587 pbh003 ERR12389586 ulu010 ERR12389614 ulu010 ERR12389613 sub008 ERR12389591 sub008 ERR12389590 tpc003 ERR12389593 tpc003 ERR12389592 bad003 ERR12389576 bad003 ERR12389575
。