How can I reformat JSON with awk?

Question

I have information as given below in a text file.

{"00:00:00:00:00:00:02:03":[{"controllerId":"onos-primary"}],"00:00:00:00:00:00:02:02":[{"controllerId":"onos-primary"}],"00:00:00:00:00:00:02:01":[{"controllerId":"onos-primary"}],"00:00:00:00:00:00:02:06":[{"controllerId":"onos-primary"}],"00:00:00:00:00:00:02:05":[{"controllerId":"onos-primary"}],"00:00:00:00:00:00:02:04":[{"controllerId":"onos-primary"}]}

I want that information to be like this.

{
"00:00:00:00:00:00:02:03":[{"controllerId":"onos-primary"}],
"00:00:00:00:00:00:02:02":[{"controllerId":"onos-primary"}],
"00:00:00:00:00:00:02:01":[{"controllerId":"onos-primary"}],
"00:00:00:00:00:00:02:06":[{"controllerId":"onos-primary"}],
"00:00:00:00:00:00:02:05":[{"controllerId":"onos-primary"}],
"00:00:00:00:00:00:02:04":[{"controllerId":"onos-primary"}]
}

How can I acheieve this using Linux commandline.? I am willing to use awk or sed or simple bash

BTW, you don't seem to be a new user. Haven't you read the [help](http://stackoverflow.com/help) on how to ask a good question yet? — devnull, Apr 07 '14 at 07:32

score 2 · Answer 1 · answered Apr 07 '14 at 08:03

2

You can use

awk '{sub('/^{/', "{\n", $0); sub('/}$/', "\n}", $0); gsub('/,/', ",\n", $0); print;}' filename

answered Apr 07 '14 at 08:03

a5hk

7,532
3
26
40

score 1 · Answer 2 · answered Apr 07 '14 at 08:22

1

My i suggest python?

python -m json.tool < file.json

And with syntax-highlighting:

python -m json.tool < file.json | highlight --syntax js -O xterm256

answered Apr 07 '14 at 08:22

phylax

2,034
14
13

score 0 · Answer 3 · answered Apr 07 '14 at 12:24

0

This might work for you (GNU sed):

sed -r 's/\{(.*)\}/{\n\1\n}/;s/,/&\n/g' file

answered Apr 07 '14 at 12:24

potong

55,640
6
51
83

How can I reformat JSON with awk?

3 Answers3