文本处理json格式

jason680

回复 1# zriplj

$ awk -F" *: *" '{gsub(/[",]/,"")}/enable/{en=$2}/name/{print $2,en}' a.json
app-mod-shop true
app-mod-sys true
app-mod-ditui true





--- some bug and modify ------------------------
$ awk -F" *: *" '{gsub(/[",]/,"")}/status/{st=$2}/name/{print $2,st}' a.json
app-mod-shop enable
app-mod-sys disable
app-mod-ditui enable

zxy877298415

回复 1# zriplj

1. awk -vRS="}" '{if(match($0,/"status": "([^"]+).*"name": "([^"]+)/,a)) print  a[2],a[1]}' file

复制代码

jason680

回复 6# zriplj

$ awk -F,  'function qq(s){return"\""s"\""}function get(s,k){if(match(s, qq(k)": *"qq("([^\"]+)"),m)){a[k]=m[1];return 1}return 0}{for(n=1;n<=NF;++n){if(get($n,"status"))fs=1;if(get($n,"name"))fn=1;if(fs*fn){print a["name"],a["status"];fs=fn=0}}}' b.json
app-mod-shop enable
app-mod-sys disable
app-mod-ditui enable

haooooaaa

error.......

jason680

回复 9# zriplj

{"code":"4001","reason":null,"result":null,"attach":[{"name":"app-mod-shop","address":"192.168.1.80:1488","enable":true,"status":"enable"},{"name":"app-mod-sys","address":"192.168.1.80:1200","enable":true,"status":"disable"},{"name":"app-mod-ditui","address":"192.168.1.80:1600","enable":true,"status":"enable"}],"success":true}

  qq function ==> 字符串 加上 双引号(")

1. 以逗号(,)为分隔符
   awk -F,

2a. 找"name":"..." 放入(关连)数组
  get($n,"name")  => match(s, qq(k)": *"qq("([^\"]+)"),m)
  放入(关连)数组  a[k]=m[1]   ( a["name"] = "app-mod-shop")

  if(get($n,"name"))fn=1;  ==> 找着了，设标志(flag)


2b. 找"status":"..." 放入(关连)数组
  get($n,"status")  => match(s, qq(k)": *"qq("([^\"]+)"),m)
  放入(关连)数组  a[k]=m[1]   ( a["status"] = "enable")

  if(get($n,"name"))fs=1;  ==> 找着了，设标志(flag)

3. fs, fn 标志都有, 打印..
if(fs*fn){print a["name"],a["status"];fs=fn=0}