取特殊字段

daixubinbin

原始文本如下：
{"basic"{"SHANAME":"test1","type":"10"},{"SHANAME":"test21","type":"221"},{"SHANAME":"test431","type":"31"},{"comp":"yyyy"}
{"basic"{"SHANAME":"@@@","type":"10"},{"SHANAME":"中文","type":"221"},{"SHANAME":"测试","type":"31"},{"comp":"yyyy"}


需要得到SHANAME后字段，最终结果如下：
"test1","test21","test431","@@@","中文","测试"


希望有不同的解法（awk、sed、grep、perl等），谢谢^_^

klainogn

1. [root home]# awk -vFS='"' '{for(i=1;i<=NF;i++){if($i=="SHANAME")printf("\"%s\",", $(i+2))}}END{print ""}' test.txt

复制代码

wh7211

回复 1# daixubinbin

1. cat 1
   
2. {"basic"{"SHANAME":"test1","type":"10"},{"SHANAME":"test21","type":"221"},{"SHANAME":"test431","type":"31"},{"comp":"yyyy"}
   
3. {"basic"{"SHANAME":"@@@","type":"10"},{"SHANAME":"中文","type":"221"},{"SHANAME":"测试","type":"31"},{"comp":"yyyy"}
   
4. 
   
5. awk -F"[{}:,]+" '{for(i=1;i<=NF;i++){if($i=="\"SHANAME\""){a=a?a","$(i+1):$(i+1)}}}END{print a}' 1
   
6. "test1","test21","test431","@@@","中文","测试"

复制代码

baby_神

1. grep -oP '(?<="SHANAME":)[^,]+' file

复制代码

cd_ly

#cat file
{"basic"{"SHANAME":"test1","type":"10"},{"SHANAME":"test21","type":"221"},{"SHANAME":"test431","type":"31"},{"comp":"yyyy"}
{"basic"{"SHANAME":"@@@","type":"10"},{"SHANAME":"中文","type":"221"},{"SHANAME":"测试","type":"31"},{"comp":"yyyy"}


# awk -F',' '{for(i=1;i<=NF;i++)if($i~/"SHANAME"/){gsub(".*SHANAME\042:","",$i);f=f?f","$ii}}END{print f}' file
"test1","test21","test431","@@@","中文","测试"

# awk '{split($0,a,/"SHANAME":"[^"]+"/,b);for(i=1;i<=length(b);i++){split(b[i],t,":";f=f?f","t[2]:t[2]}}END{print f}' file
"test1","test21","test431","@@@","中文","测试"

# awk '{for(i=1;i<=NF;i++){split($i,t,":";f=f?f","t[2]:t[2]}}END{print f}' FPAT='SHANAME":"[^"]+"' file
"test1","test21","test431","@@@","中文","测试"

ll104567

perl -ne '@a=$_=~/(?<=SHANAME"([^,]+)(?=,"/g;push @x,@a;END{print join ",",@x}'

legs

1. perl -0nE'say join",",/SHANAME":([^,]+)/g'

复制代码

ll251

1. awk -F'[,:]' '{for(i=1;i<=NF;i++){if($i~/SHANAME/)res=res","$(i+1)}}END{sub(",","",res);print res}' 1

复制代码

gigabit

1. cat 1.txt | grep -oP '(?<=E":)[^,]+,' | xargs -d '\n' | sed -e 's/[ ]//g' -e 's/,$//g' >2.txt
   
2. cat 2.txt

复制代码