Using JSON format, for bookmarks in my case, it's nice to able to clean them and retain only useful (a list of named) attributes (these occur at all levels of the structure). As output, the whole JSON hierarchy has to…
I have a weird CSV with one column being JSON data of quite a large size and one is a name. Showing proper JSON formatting for clarity, but file is flat with no new line chars. name, { "field1": {"name":"foo",…
I have the following JSON object: { ..., "projects": [ "abc", "xyz" ], ... } And I want it transformed to: { "abc": { "name": "abc" }, "xyz": { "name": "xyz" }, } I'm having trouble creating this. I've tried…
I have the following JSON structure: [ { "key11": "value11", "key12": "value12", "key13": "value13", "key14": "value14" }, { "key21": "value21", "key22": "value22", "key23": "value23", "key24": "value24" }, { "key31": "value31", "key32": "value32", "key33": "value33", "key34": "value34" } ] How do…
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…
I'm not really sure on how to phrase this question so lemme give an example: I have two types of JSON document formats for a large amount of files. Most of the contents apart from one object is irrelevant to…
As part of data preprocessing I need to remove all empty values from an input JSON like empty arrays [], empty objects {}, empty strings ""/" "/"t", objects with empty keys {"":5} and I need to do that recursively. I…
I have the following json: { "virtual_machines": [ { "guest_name": "guest1", "mac_address": [ "00:01:02:03:04:05" ], "vm_network": { "00:01:02:03:04:05": { "ipv4": [ "192.168.2.23" ], "ipv6": [ "fe80::896:2e12:c059:4237" ] }, "c2:e3:7c:ac:60:c5": { "ipv4": [ "10.42.0.0" ], "ipv6": [] }, "5a:00:fb:5e:3d:65": { "ipv4":…
How can I use jq to sort an array of objects by an IPv4 address value as a 32-bit integer rather than alphanumerically? An illustration of what I mean with some extra formatting for visual clarity: $ echo ' {"name":…
I've got two files containing compressed JSONs. All JSONs having the same root fragments "id" and "test": file1.json: {"test":{"a":2},"id":"850303847"} {"test":{"a":3},"id":"2742540872"} {"test":{"a":4},"id":"1358887220"} file2.json: {"test":{"b":3},"id":"850303847"} {"test":{"b":3},"id":"2742540872"} {"test":{"b":4},"id":"1358887220"} file3.json {"test":{"c":8},"id":"850303847"} {"test":{"c":4},"id":"2742540872"} {"test":{"c":5},"id":"1358887220"} I would like to merge these Files based on it's IDs…