Extract values from JSON object using standard utilities

Question

I have a txt file and its content is as follows. I am trying leave only value like 12, [email protected] and delete brackets, quotation mark, comma, and the key. Could someone help me what I miss or go wrong with my command line? Thank you!

{
"id": 12,
"email": "[email protected]",
"first_name": "Rachel",
"last_name": "Howell",
"avatar": "https://s3.amazonaws.com/uifaces/faces/twitter/hebertialmeida/128.jpg",
}

Now, the result I can output is that

{
    12,
    "[email protected]",
    "Rachel",
    "Howell",
    "https://s3.amazonaws.com/uifaces/faces/twitter/hebertialmeida/128.jpg",
 }

What I expected is:

12
[email protected]
Rachel
Howell
https://s3.amazonaws.com/uifaces/faces/twitter/hebertialmeida/128.jpg

Here is my command:

sed -e 's/[{]//g' | cut -d':' -f '2' test.txt

as mentioned by @oguzismail, you also check stackoverflow.com/questions/1955505/… — amit bhosale
– amit bhosale, Commented Jun 17, 2020 at 7:26
jq is a good way to achieve what I expected, but I would like to practice using sed, cut to make the same result =) — Oscar
– Oscar, Commented Jun 17, 2020 at 7:31
sed can manage json files only, if they use simple data structures and then always the same. Pitfalls are recursive data structures or different members/order/datatypes/line breaks. So it is always better to use context sensitive json tools like jq. — Wiimm
– Wiimm, Commented Jun 17, 2020 at 11:36
By the way I never used sed with the option -e on linux like for grep... is that really needed ? — ATR
– ATR, Commented Jun 17, 2020 at 14:51

oguz ismail · Accepted Answer · 2020-06-17 07:23:10Z

2

With jq, it'd be:

jq -r '.[]' file

answered Jun 17, 2020 at 7:23

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ATR · Accepted Answer · 2020-06-17 07:47:29Z

0

If you only wanna use sed cut and grep, I would recommand you that :

sed "s/}//g;s/{//g;s/\"//g;s/,//g;s/\ //g" test.txt | cut -d":" -f2 | egrep "..*"

But there's way more officient.

--

EDIT : description of the command :

sed "s/}//g;s/{//g;s/\"//g;s/,//g;s/\ //g"

-> removes {}",

cut -d":" -f2

-> only takes the 2nd part

egrep "..*"

-> only takes the lines which contain something

edited Jun 17, 2020 at 7:47

answered Jun 17, 2020 at 7:36

ATR

1077 bronze badges

3 Comments

Oscar Over a year ago

Why do we put the file name before cut instead of putting it at the end of command? Thaks! @ ATR

ATR Over a year ago

@Oscar Sed must have an entry and this one is the file test.txt. Then the pipe "|" gives sed's output to cut and from cut to grep. If you specify the file only for cut, sed won't actually have anything to do with. That's why in your command output there was still the { and }

Oscar Over a year ago

Thank you for the feedback! @ATR

Collectives™ on Stack Overflow

Extract values from JSON object using standard utilities

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related