Linux里，如何使用awk进行提取

作者: Ternq8 | 来源:发表于2017-11-02 17:55 被阅读37次

Linux里，如何使用awk进行提取
sed & awk & tr
linux中awk的复习
Linux
awk 命令使用方法
Linux文本编辑三剑客之---awk的使用
Linux使用awk命令进行日志分析
Linux常用命令总结
常用命令-awk
Linux awk命令详解

实例一：如何用awk 来进行row的filter。

dhcp-129-94:Desktop ye.liu$ awk '{if ($6=="+"){print}}' RefSeq_Genes.dms |head
chr1    201283451   201332993   NM_000299   0   +   201283702   201328836   0   15  453,104,395,145,208,178,63,115,156,177,154,187,85,107,2920, 0,10490,29714,33101,34120,35166,36364,36815,38526,39561,40976,41489,42302,45310,46622,
chr1    201283451   201332993   NM_001005337    0   +   201283702   201328836   0   14  453,104,395,145,208,178,115,156,177,154,187,85,107,2920,    0,10490,29714,33101,34120,35166,36815,38526,39561,40976,41489,42302,45310,46622,
chr1    117367432   117528870   NM_006699   0   +   117368183   117522957   0   13  1053,256,97,119,81,95,124,94,116,220,173,116,6046,  0,34753,38116,47280,53136,74798,93056,98901,125714,129330,131949,135422,155392,
chr1    167721949   167791919   NM_001146191    0   +   167722151   167787921   0   3   293,167,4100,   0,43633,65870,
chr1    150982022   150995638   NM_003568   0   +   150983105   150995322   0   14  357,97,91,97,95,114,91,80,60,85,96,59,123,379,  0,464,1067,1315,1952,2258,2563,4313,4579,5849,6068,6260,12554,13237,
chr1    167721949   167791919   NM_003953   0   +   167722151   167787921   0   6   293,167,214,133,103,4100,   0,43633,50325,51286,54114,65870,
chr1    167721949   167791919   NM_024569   0   +   167722151   167787844   0   5   293,167,214,133,4100,   0,43633,50325,51286,65870,
chr1    184387015   184629021   NM_030806   0   +   184477509   184619556   0   6   353,218,95,77,61,9504,  0,90370,120572,203723,211385,232502,
chr1    243256004   243500092   NM_001350247    0   +   243308151   243499785   0   19  236,153,86,114,126,129,65,97,189,139,153,135,117,143,128,109,132,127,337,   0,14100,14973,18538,30267,37086,48708,51782,51984,60750,74535,85034,88210,122716,159697,161963,170422,233009,243751,
chr1    243256004   243500092   NM_001350249    0   +   243271051   243499785   0   18  236,166,86,114,126,129,65,189,139,153,135,117,143,128,109,132,127,337,  0,14087,14973,18538,30267,37086,48708,51984,60750,74535,85034,88210,122716,159697,161963,170422,233009,243751,

#根据strand的正负，把hg38的RefSeq文档分开了
dhcp-129-94:Desktop ye.liu$ awk '{if ($6=="+"){print}}' RefSeq_Genes.dms > F.RefSeq_Genes.dms
dhcp-129-94:Desktop ye.liu$ awk '{if ($6=="-"){print}}' RefSeq_Genes.dms > R.RefSeq_Genes.dms

实例二：如何用awk来筛某几列。

tkx424:p8_c2 ye.liu$ awk '{for(i=8;i<=8;i++)print $i}' PST.DEG.coding.unique.tsv >./0.terminal/PST.DEG.coding.unique.gene.tsv | awk '{for(i=8;i<=8;i++)print $i}' PST.DEG.noncoding.unique.tsv > ./0.terminal/PST.DEG.noncoding.unique.gene.tsv 
tkx424:p8_c2 ye.liu$  awk '{for(i=8;i<=8;i++)print $i}' PxT.DEG.coding.unique.tsv > ./0.terminal/PxT.DEG.coding.unique.gene.tsv | awk '{for(i=8;i<=8;i++)print $i}' PxT.DEG.noncoding.unique.tsv > ./0.terminal/PxT.DEG.noncoding.unique.gene.tsv
tkx424:p8_c2 ye.liu$ awk '{for(i=8;i<=8;i++)print $i}' xST.DEG.coding.unique.tsv >./0.terminal/xST.DEG.coding.unique.gene.tsv | awk '{for(i=8;i<=8;i++)print $i}' xST.DEG.noncoding.unique.tsv > ./0.terminal/xST.DEG.noncoding.unique.gene.tsv 
tkx424:p8_c2 ye.liu$ awk '{for(i=8;i<=8;i++)print $i}' xxT.DEG.coding.unique.tsv >./0.terminal/xxT.DEG.coding.unique.gene.tsv | awk '{for(i=8;i<=8;i++)print $i}' xxT.DEG.noncoding.unique.tsv > ./0.terminal/xxT.DEG.noncoding.unique.gene.tsv 
tkx424:p8_c2 ye.liu$