Text in file manipulation

Question

I have a text file with text like this:

{"id":2705,"status":"Analyze","severity":"Critical",Blah Blah ... "file":"/home/foo.c","message":"Message is...","url":"http://aaa..."}
{"id":2706,"status":"Fix","severity":"Low",Blah Blah ... "file":"/home/foo1.h","message":"Message2 is...","url":"http://bbb..."}

I would like to have bash script, that reads file, and for each line use all pairs of data as variables (for example id=2705, status="Analyze"...) and echo them.

What did you try to solve this problem? Posting it and letting us know what failed will attract more answers. — Inian, Aug 31 '16 at 13:15
Looking for a method to split into pairs. Not sure how to do it. Want to have: echo "id=2705" echo "status=Analyze"... — OkyDokyman, Aug 31 '16 at 13:19
You may find some inspiration here: http://stackoverflow.com/questions/19511851/parsing-json-data-columnwise-in-shell — Ruud Helderman, Aug 31 '16 at 13:20

score 1 · Accepted Answer · answered Aug 31 '16 at 13:23

1

awk  'BEGIN{RS=",";FS=":";OFS="="}{$1=$1;gsub("}|{|\"","")}1' infile
id=2705
status=Analyze
severity=Critical
Blah Blah ... file=/home/foo.c
message=Message is...
url=http=//aaa...
id=2706
status=Fix
severity=Low
Blah Blah ... file=/home/foo1.h
message=Message2 is...
url=http=//bbb...

answered Aug 31 '16 at 13:23

P....

17,421
2
32
52

+1 for nice solution! The thing that keeps nagging me is any `json` aware tool would be even more ideal, as this does not guarantee when the formatting of the file is changed to a linear style. – Inian Aug 31 '16 at 13:27
I agree, Ideally json aware tool should be used. – P.... Aug 31 '16 at 13:29
Exactly what I wanted! Thanks – OkyDokyman Aug 31 '16 at 13:36

Text in file manipulation

1 Answers1