Question 185215 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Convert json-lines to tsv, producing a separate line for each array item

I have the following input file

["alice", ["foo", "bar", "baz"]]
["bob", ["qux", "quux"]]
⋮

and I want to convert it to a tab separated file that looks like the following (note the lack of quotes)

alice   foo
alice   bar
alice   baz
bob     qux
bob     quux
⋮

All the array elements are guaranteed to be strings (no nulls).
Can you help me come up with a jq script to achieve this?

Tags:

2

Answers


  1. 0

    Replace the last item (or equally the .[1] item) with each of its own items (.[]), then turn all of it into tab-separated values using @tsv:

    jq -r 'last = last[] | @tsv' input.json

    alice   foo
alice   bar
alice   baz
bob qux
bob quux

    Demo

    Login or Signup to reply.
  2. 0

    Here’s another way to do it by placing the first element in an array and then using the built-in combinations.

    jq --raw-output '.[0]=[.[0]] | combinations | @tsv' input.json

    Try it on jqplay.org.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search