how to parse specific values from multiple JSON objects into csv using jq

Question

I have following json

[
   {
      "ip":"105.105.105.105",
      "timestamp":"1543746097",
      "ports":[
         {
            "port":80,
            "proto":"tcp",
            "status":"open",
            "reason":"syn-ack",
            "ttl":128
         }
      ]
   },
   {
      "ip":"105.105.105.105",
      "timestamp":"1543746097",
      "ports":[
         {
            "port":53,
            "proto":"tcp",
            "status":"open",
            "reason":"syn-ack",
            "ttl":128
         }
      ]
   }
]

I want to extract ports to simple csv output

80,53

I tried

jq -r '.[]."ports" | map(.port) | @csv' 105.105.105.105_tcp.json

and

jq -r '.[]."ports" | map(.port) | join(",")' 105.105.105.105_tcp.json

but none of them work.

Haxiel · Accepted Answer · 2018-12-02 14:18:13Z

5

Here's a jq-only solution:

jq -r '[ .[].ports[].port ]|@csv' network.json
80,53

The approach here is to retrieve the port numbers, wrap them into an array, and then convert it to the CSV format.

answered Dec 2, 2018 at 14:18

Haxiel

8,7291 gold badge23 silver badges32 bronze badges

Add a comment |

Petr Javorik · Accepted Answer · 2018-12-02 12:51:47Z

0

I was able to get desired output by

jq -r '.[]."ports" | .[].port' 105.105.105.105_tcp.json | tr '\n' ',' | sed 's/,*$//g'

However I'm wondering if it can be done in more elegant way.

answered Dec 2, 2018 at 12:51

Petr Javorik

1331 silver badge6 bronze badges

Add a comment |

Dmitry L. · Accepted Answer · 2019-01-09 17:02:01Z

0

bash $ jtc -w'<port>l+0' -jr input.json | sed s/[][]//g 
 80, 53 
bash $

jtc will extract and print all ports and wrap those into the array. sed is needed to drop the arrays encasing

answered Jan 9, 2019 at 17:02

Dmitry L.

512 bronze badges

Add a comment |

Stack Exchange Network

how to parse specific values from multiple JSON objects into csv using jq

3 Answers 3

You must log in to answer this question.

Hot Network Questions

how to parse specific values from multiple JSON objects into csv using jq

3 Answers 3

You must log in to answer this question.

Related

Hot Network Questions