如何刪除指定列

紫風(fēng)8824

文件123.txt 有200多列的數(shù)據(jù)，請(qǐng)問如何刪除第29,53，55,66,72,101,161這7列數(shù)據(jù)？求指教~謝謝！

haooooaaa

1. awk -vD='29,53,55,66,72,101,161' -F, -vOFS=, '{split(D,t);for(j in t){for(i=t[j]-j;++i<=NF;)$i=$(i+1);NF--}}1'  file

復(fù)制代碼

jason680

回復(fù) 1# 紫風(fēng)8824

$ seq 10 | awk -vD="1,3,5,8" 'BEGIN{split(D,a,",");c=1}NR==a[c]{c++;next}1'
2
4
6
7
9
10

   

songyc_2015

1. $ cat file
   
2. a,b,c,d,e,f,g,h,i,j,k,l
   
3. $ awk --re-interval -vD='1,3,5,11' 'BEGIN{l=split(D,a,",")}{for(i=1;i<=l;i++){$0=gensub("(([^,]*,?){"a[i]-i"})([^,]+,?)(.*)","\\1\\4","1")}}1' file
   
4. b,d,f,g,h,i,j,l
   
5. $ awk -vD='1,3,5,11' -F, -vOFS=, '{split(D,t);for(j in t){for(i=t[j]-j;++i<=NF;)$i=$(i+1);NF--}}1' file
   
6. b,d,f,g,i,j,k,l

復(fù)制代碼

@haooooaaa和你寫的結(jié)果不一樣。。。

LikeLx

理解錯(cuò)了...

dn833

1. echo {1..200}|awk '{$29=$53=$55=$66=$72=$101=$161="";print $0}'

復(fù)制代碼

haooooaaa

1. echo 'a,b,c,d,e,f,g,h,i,j,k,l' | awk -vD='1,3,5,11' -F, -vOFS=, '{split(D,t);for(j in t){for(i=t[j]-j;++i<=NF;)$i=$(i+1);NF--}}1'
   
2. b,d,f,g,h,i,j,l
   

復(fù)制代碼

回復(fù) 4# songyc_2015

1. [root@test /tmp]$ cat b
   
2. 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20
   
3. 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20
   
4. 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20
   
5. [root@test /tmp]$ awk -vD="1,3,5,8,15,20" -F, -vOFS=, '{split(D,t);for(j in t){for(i=t[j]-j;++i<=NF;)$i=$(i+1);NF--}}1' b
   
6. 2,4,6,7,9,10,11,12,13,14,16,17,18,19
   
7. 2,4,6,7,9,10,11,12,13,14,16,17,18,19
   
8. 2,4,6,7,9,10,11,12,13,14,16,17,18,19
   

復(fù)制代碼

songyc_2015

回復(fù) 7# haooooaaa
我awk有bug么？

haooooaaa

回復(fù) 8# songyc_2015


    我那個(gè)是  cygwin 里的。 版本是 4.1.3

songyc_2015

回復(fù) 9# haooooaaa
好吧。。。。。。