抽取列和抽取引號(hào)內(nèi)的結(jié)合

skypeleo

舉例：

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

抽取第二列 +  第一對(duì)引號(hào)內(nèi)的第二列  + 第二對(duì)引號(hào)內(nèi)的全部

結(jié)果為：

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
   

復(fù)制代碼

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

復(fù)制代碼

ly5066113

回復(fù) 1# skypeleo

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

復(fù)制代碼

waker

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

復(fù)制代碼

seanking1987

2樓，3樓本質(zhì)一樣的~~

jason680

回復(fù) 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

抽取第二列 +  第一對(duì)引號(hào)內(nèi)的第二列  + 第二對(duì)引號(hào)內(nèi)的全部

$ 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

回復(fù) 5# seanking1987


    2樓還是比較嚴(yán)謹(jǐn)，如果引號(hào)出現(xiàn)得更后面，3樓就有問(wèn)題。

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]#

復(fù)制代碼

ljwd1000

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

復(fù)制代碼