Cannot index string with string "name" - CSV output from JSON

Question

I'm trying to output data in a JSON file I have with a few thousand rows to CSV. The JSON components follow this general pattern:

{
  "name": "pickles",
  "aliases": [
    "birds"
  ]
}
{
  "name": "cheese",
  "aliases": [
    "cheese1",
    "cheese2"
  ]
}

Some of the aliases have more than 1 value (up to four) and some just have one. I'm looking for a CSV output to have two columns - one for name, and one for aliases, where the value in name will be in the name column and value for aliases will be in the aliases column (see below).

name,aliases
pickles,birds
cheese, cheese1
cheese, cheese2

I'm trying to figure out which jq command(s) to use to get this output, but I'm stuck with the error Cannot index string with string "name"

I've tried a few jq commands and I'm getting similar errors. Most recently I tried:

jq -r '.[] | . as {$name} | [$name, .name, .aliases] | @csv' filename.json

Paolo · Accepted Answer · 2025-02-27 15:02:57Z

-1

You could use --slurp to read in the stream as an array:

$ jq -s -r '("name,aliases"), (.[] | "\(.name),\(.aliases[])")' filename.json
name,aliases
pickles,birds
cheese,cheese1
cheese,cheese2

answered Feb 27 at 15:02

Paolo

26.6k8 gold badges51 silver badges88 bronze badges

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

1 Comment

Paolo Feb 28 at 8:14

Why the downvote?

Collectives™ on Stack Overflow

Cannot index string with string "name" - CSV output from JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related