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

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.

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

add a comment |

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.

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

add a comment |

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.

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

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.

json jq

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

edited Dec 2 '18 at 14:41

Jeff Schaller

38.7k1053125

asked Dec 2 '18 at 12:42

Petr Javorik

1184

asked Dec 2 '18 at 12:42

Petr Javorik

1184

asked Dec 2 '18 at 12:42

Petr Javorik

1184

add a comment |

2 Answers
2

active

oldest

votes

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 '18 at 14:18

Haxiel

1,154310

add a comment |

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 '18 at 12:51

Petr Javorik

1184

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f485477%2fhow-to-parse-specific-values-from-multiple-json-objects-into-csv-using-jq%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

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 '18 at 14:18

Haxiel

1,154310

add a comment |

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 '18 at 14:18

Haxiel

1,154310

add a comment |

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 '18 at 14:18

Haxiel

1,154310

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 '18 at 14:18

Haxiel

1,154310

answered Dec 2 '18 at 14:18

Haxiel

1,154310

answered Dec 2 '18 at 14:18

Haxiel

1,154310

answered Dec 2 '18 at 14:18

Haxiel

1,154310

add a comment |

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 '18 at 12:51

Petr Javorik

1184

add a comment |

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 '18 at 12:51

Petr Javorik

1184

add a comment |

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 '18 at 12:51

Petr Javorik

1184

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 '18 at 12:51

Petr Javorik

1184

answered Dec 2 '18 at 12:51

Petr Javorik

1184

answered Dec 2 '18 at 12:51

Petr Javorik

1184

answered Dec 2 '18 at 12:51

Petr Javorik

1184

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Unix & Linux Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vrftjkry