抽取列和抽取引号内的结合

skypeleo

举例：

abc efg   "get word1"  "how are you"  123 456
hij  klm  "get word2"  "how do you do" 789 123

抽取第二列 +  第一对引号内的第二列  + 第二对引号内的全部

结果为：

efg  word1  how are you
klm word2  how do you do

haooooaaa

1. [root@test /tmp]$ awk -F\" '{split($1,a," ");split($2,b," ");print a[2],b[2],$4}' c.txt
   
2. efg word1 how are you
   
3. klm word2 how do you do
   

复制代码

1. Get-Content .\c.txt | foreach {if ($_ -match '\w+ +(\w+) +"\w+ +(\w+)" +"([^"]+)"'){Write-Host $matches[1..3]}}
   
2. efg word1 how are you
   
3. klm word2 how do you do

复制代码

ly5066113

回复 1# skypeleo

1. awk -F \" '{split($1" "$2,a,/ +/);print a[2],a[4],$4}' file

复制代码

waker

1. 
   
2. while read line
   
3. do
   
4. eval set -- $line
   
5. echo $2 ${3##* } $4
   
6. done <urfile
   

复制代码

seanking1987

2楼，3楼本质一样的~~

jason680

回复 1# skypeleo

What You Want Is What You Code(WYWIWYC)

abc efg   "get word1"  "how are you"  123 456
hij  klm  "get word2"  "how do you do" 789 123

抽取第二列 +  第一对引号内的第二列  + 第二对引号内的全部

$ awk 'function get(str,n){split(str,a," ");return(a[n])}function qq(q,n,c){c=1;for(n=1;n<=NF;n++){$c=q?$c" "$n:$n;if($n~/^"/)q=1;if($n~/"$/)q=0;gsub(/"/,"",$c);if(!q)c++}NF=c-1}{qq();print $2,get($3,2),$4}' FILE
efg word1 how are you
klm word2 how do you do

efg word1 how are you
klm word2 how do you do

   

hjfeng1988

回复 5# seanking1987


    2楼还是比较严谨，如果引号出现得更后面，3楼就有问题。

hjfeng1988

1. [root@66a awk]# echo -e '1 "2 3 4 5" 6 "7" "8 9" 10\n1 2 3 "4 5" 6 "7" "8 9" 10'
   
2. 1 "2 3 4 5" 6 "7" "8 9" 10
   
3. 1 2 3 "4 5" 6 "7" "8 9" 10
   
4. [root@66a awk]# echo -e '1 "2 3 4 5" 6 "7" "8 9" 10\n1 2 3 "4 5" 6 "7" "8 9" 10' | awk '{printf $2" ";FS="\"";$0=$0;split($2,b," ");print b[2],$4;FS=" "}'
   
5. "2 3 7
   
6. 2 5 7
   
7. [root@66a awk]#

复制代码

ljwd1000

1. sed 's/[^ ]* \+\([^ ]*\)[^\"]*\"[^ ]* \+\([^\"]*\)\"[^\"]*\"\([^\"]*\).*/\1 \2 \3/'

复制代码