I have JSON data files that I'd like to modify somewhat. From: { "alpha": "...", "beta": [ ... ], "delta": { ... }, "gamma": "..." } to: { "alpha": "...", "epsilon" : { "beta": [ ... ], "delta": { ...…
Im trying to list the image tags from ECR repo using below command on windows aws ecr list-images --repository-name plat | jq '.imageIds | map (.imageTag) | sort | .[]' | sort -r | head -1 I installed jq utility…
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":…