awk列匹配

linuxbody

1. a b c
   
2. 1 2 3
   
3. x y z
   
4. 
   
5. awk '/c/{这里怎么写？}'
   
6. 
   
7. 结果为
   
8. 3
   
9. z

复制代码

moperyblue

1. awk '!k{while(i++<NF)if($i~/c/)k=i;next}{print $k}'

复制代码

sunzhiguolu

1. perl -anle 'print $F[-1] if($F[-1] ne "c")' f

复制代码

zy86416779

1. [root@CentOS_6 experiment]# awk -f test.awk test.txt
   
2. 2
   
3. y
   
4. [root@CentOS_6 experiment]# cat test.awk
   
5. {
   
6.   if(NR==1){
   
7.     for(i=1;i<=NF;i++){
   
8.       if($i=="b"){
   
9.         j=i
   
10.         #print j
    
11.         break
    
12.       }  
    
13.     }
    
14.     next
    
15.   }
    
16.   
    
17.   print $j
    
18. }
    
19. [root@CentOS_6 experiment]# cat test.txt
    
20. a b c
    
21. 1 2 3
    
22. x y z

复制代码

jason680

回复 1# linuxbody

$ awk -vk=a 'NR==1{for(n=1;n<=NF;++n)if($n==k)next;if(n>NF){print "DIDNOT match key("k") in first line: "$0;exit}}{print $n}' FILE
1
x

$ awk -vk=b 'NR==1{for(n=1;n<=NF;++n)if($n==k)next;if(n>NF){print "DIDNOT match key("k") in first line: "$0;exit}}{print $n}' FILE
2
y

$ awk -vk=c 'NR==1{for(n=1;n<=NF;++n)if($n==k)next;if(n>NF){print "DIDNOT match key("k") in first line: "$0;exit}}{print $n}' FILE
3
z

$ awk -vk=d 'NR==1{for(n=1;n<=NF;++n)if($n==k)next;if(n>NF){print "DIDNOT match key("k") in first line: "$0;exit}}{print $n}' FILE
DIDNOT match key(d) in first line: a b c

zl624867243

1. #!/usr/bin/python
   
2. #coding:utf8
   
3. f = open(r'/root/file','r')
   
4. y=[]
   
5. for i in f:
   
6.         u = i.split()
   
7.         y.append(u[2])
   
8. for n in y:
   
9.         if "c" not in n:
   
10.                 print n
    

复制代码

3
z

ll104567

cat file|awk 'NR==1{for(i=1;i<=NF;i++){if($i=="c"){a[i]=1}};next}{for(i=1;i<=NF;i++){if(a[i]){printf $i FS}}print x}'
3
z

jcdiy0601

1. awk '/c/{a=NF;getline}{print $a}' file

复制代码

cd_ly

awk 'NR==1{for(i=1;i<=NF;i++)if($i=="c")a=i;next}{print $a}' a1.txt

moperyblue

1. awk 'k{print $k}!k{while(i++<NF)if($i~/c/){k=i;break}}'

复制代码