find and replace a value in a json file using bash

Question

I have several .json files similar to this.

{
    "AcquisitionNumber": 1,
    "TotalReadoutTime": 0.035,
    "IntendedFor": "func/sub-02_task-rest_run-01_bold.nii.gz"
}

I want to change the sub number in the "IntendedFor" line using a bash variable, looping over different subs.For example if sub is 03:

sub=03
echo $sub
03

How can I change the value of sub-02 to sub-03 using this bash variable?

A huge list of alternatives to jq here: https://stackoverflow.com/a/49011455/2440 — Sire, Oct 08 '21 at 11:26

oguz ismail · Accepted Answer · 2019-04-12T10:11:34.420

Use jq:

jq --arg sub "$sub" '.IntendedFor |= sub("(?<=sub-)[^_]+"; $sub)' file

See this online example

Note that your jq binary must be compiled with regex support in order to use sub function.

And, you can implement inline editing using a for loop and temporary files:

sub=03

for jsonfile in *.json; do
    tempfile=$(mktemp -u)
    jq --arg sub "$sub" '.IntendedFor|=sub("(?<=sub-)[^_]+";$sub)' "$jsonfile" > "$tempfile"
    mv "$tempfile" "$jsonfile"
done

Cyrus · Answer 2 · 2018-10-07T14:52:10.590

2

With jq and bash:

value=$(jq -r '.IntendedFor' file)
new_value="${value/sub-02/sub-03}"
jq --arg new "$new_value" '.IntendedFor |= $new' file

Output:

{
  "AcquisitionNumber": 1,
  "TotalReadoutTime": 0.035,
  "IntendedFor": "func/sub-03_task-rest_run-01_bold.nii.gz"
}

edited Oct 07 '18 at 14:52

answered Oct 07 '18 at 14:23

Cyrus

77,979
13
71
125

you can use jq's `--arg` option to pass shell variables to jq – oguz ismail Oct 07 '18 at 14:26
1

Thanks, that makes it easier. – Cyrus Oct 07 '18 at 14:27
This does not change the original file but outputs the result to the terminal, right? – Ilkay Isik Oct 07 '18 at 15:09

peak · Answer 3 · 2018-10-08T05:05:21.050

1

Using sponge (part of moreutils):

for f in *.json; do
  jq --arg sub "$sub" '.IntendedFor |= sub("/sub-[^_]+";"/sub-"+$sub)' "$f" | sponge "$f"
done

In any case, a simple regex suffices.

sponge for Windows

See:

edited Oct 08 '18 at 05:05

answered Oct 07 '18 at 19:51

peak

88,177
15
123
150

Ljm Dullaart · Answer 4 · 2018-10-08T17:38:18.657

0

There are better ways of doing this, but there is a bash-solution:

#!/bin/bash
fromstring="sub-02"
tostring="sub-03"

while read line; do
    case "$line" in
    (*IntendedFor*) echo $(line/$fromstring/$tostring) ;;
    (*)  echo $line ;;
    esac
 done < JSONfile

edited Oct 08 '18 at 17:38

answered Oct 07 '18 at 14:16

Ljm Dullaart

3,247
2
14
26

I didn't downvote, but your use of `cat` is a *UUOc` (Unnecessary Use Of `cat`)*. Unless you are concatenating files, if you find yourself doing `cat somethingelse`, then it is probably a UUOc. Here using *redirection*, e.g. `while read line; do ... done – David C. Rankin Oct 07 '18 at 19:36
As I said, "There are better ways of doing this". But I thought it to be a nice puzzle for doing it in bash only. I removed the `cat` from the answer, which makes it work completely in `bash`, without external programs. – Ljm Dullaart Oct 08 '18 at 17:37

find and replace a value in a json file using bash

4 Answers4

sponge for Windows