Update values in one array based on another in the same JSON file

Question

I have a JSON file like this:

{
    "download": [0, 0, 0, 0],
    "files": [ "file1.txt", "file1.iso", "file2.txt", "file2.iso" ] 
}

For each element in files[] ending in .txt I want to set the corresponding element in download[] to 1. How do I do that in JQ? I googled around but don't really understand JQ syntax.

oguz ismail · Accepted Answer · 2021-06-08 04:20:44Z

2

In this case constructing download from scratch would be much easier.

.download = (.files | map(if endswith(".txt") then 1 else 0 end))

^{Online demo}

But the title asks how to update one array based on another?, and here is one way of doing it:

.download = reduce (.files | path(.[] | select(endswith(".txt")))) as $p (.download; setpath($p; 1))

^{Online demo}

edited Jun 8, 2021 at 4:20

answered Jun 8, 2021 at 4:11

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zencraft Over a year ago

Thanks, actually I figured out the first solution with some trial and error but the second one is super useful!

Collectives™ on Stack Overflow

Update values in one array based on another in the same JSON file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related