[SOLVED] How to segregate a section from big file?

james000 · 11-30-2018, 05:19 PM

Hello,

I need to know all IP range (ip_prefix), associated with us-west-2 region only from this link - https://ip-ranges.amazonaws.com/ip-ranges.json (it can be opened in wordpad for better visibility)
Please suggest, how would I do it. If vi, awk or sed is needed, I have downloaded it on my linux server.

Thanks

berndbausch · 11-30-2018, 06:03 PM

It might be possible with standard text processing tools like awk, but ideally, you need a tool that understands JSON. Such as jq.

Code:

curl https://ip-ranges.amazonaws.com/ip-ranges.json | jq '.prefixes[] | select(.region == "us-west-2")' | more

This gets the prefixes array from the data, then selects the array elements with the desired region.

jq is available from Ubuntu repos. Not sure about other distros.

Reference: jq manual

james000 · 11-30-2018, 09:03 PM

Thanks much. It solved my problem.