Linux   发布时间:2022-04-01  发布网站:大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了AWK过滤CSV文件大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。

概述

我想过滤掉第3列中“同义”的行.命令如下 awk '$3 !~ /^synonymous/' fileCSV.csv > fileCSV2.csv 但是fileCSV2.csv在第3列中仍然包含单词“synonymous”.我想知道可能出错了什么? fileCSV.csv中的两行: "exonic","lINC00115","synonymous SNV","uc010nxx.2:c.C299T:
我想过滤掉第3列中“同义”的行.命令如下
awk '$3 !~ /^synonymous/' fileCSV.csv > fileCSV2.csv

但是fileCSV2.csv在第3列中仍然包含单词“synonymous”.我想知道可能出错了什么?

fileCSV.csv中的两行:

"exonic","LINC00115","synonymous SNV","uc010nxx.2:c.C299T:p.p100L","0.99",0.56,rs3115849,chr1,762273,G,A,"chr1","762273",".","G","A","30483.62","PASS","AC=24;AF=1.00;AN=24;DP=2972;FS=0.000;MLEAC=8;MLEAF=1.00;MQ0=0;VQSLOD=19.50;culprit=FS;set=Intersection","GT:AD:DP:GQ:PL","1/1:0,2:2:6:66,6,0",297:297:99:10476,951,304:304:99:10098,950,295:295:99:9869,929,292:292:99:8655,895,304:304:99:10006,965,179:179:99:5862,568,273:273:99:9328,851,279:279:99:7946,850,283:283:99:9214,866,8:8:21:229,21,456:456:99:16385,1285,0"    
"exonic","SAMD11","uc001abw.1:c.T1027C:p.W343R","559;Name=lod=249",1.00,rs6672356,1,0.916445,N,0.0,T,B,0.998605,4.19E-4,3.17,877831,C,"877831","T","C","3594.56","AC=24;AF=1.00;AN=24;DP=387;FS=0.000;MLEAC=8;MLEAF=1.00;MQ=60.00;MQ0=0;VQSLOD=15.00;culprit=DP;set=Intersection",3:3:9:97,9,3:3:12:113,12,64:64:99:1805,189,57:57:99:1605,168,30:30:90:768,90,69:69:99:2026,216,15:15:45:428,45,23:23:81:809,81,22:22:69:562,69,40:40:99:1142,117,3:3:9:94,58:58:99:14,7,0"

解决方法

如果您的fileCSV.csv具有由您需要的列分隔的列
awk -F,'$3 !~ /^synonymous/' fileCSV.csv > fileCSV2.csv

如果-F不适用于您的awk版本,请尝试

awk 'BEGIN{FS=","} $3 !~ /^synonymous/' fileCSV.csv > fileCSV2.csv

编辑:你还需要“虑到,所以使用/ ^”同义/

大佬总结

以上是大佬教程为你收集整理的AWK过滤CSV文件全部内容,希望文章能够帮你解决AWK过滤CSV文件所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。