JAVA: How to find all matches of a substring in a nested JSONString and replace with some text

Question

JSON String looks like

{
{"widget": {
    "debug": "on",
    "window": {
        "title": "Sample Konfabulator Widget",
        "name": "main_window",
        "width": 500,
        "height": 500,
        "stamp" : "randomtestcasenumberwithtimeID2",
        "case" : 1
    },
    "image": { 
        "src": "Images/Sun.png",
        "name": "sun1",
        "hOffset": 250,
        "vOffset": 250,
        "stamp" : "randomtestcasenumberwithtimeID3"
    
    },
}
}

I want to replace all instances of "stamp" with something static such "stamp" : "Testing". How would I go about this? please note the value of "stamp" is random.

So after the search and replace both instance of stamp should have same value "Testing" Example

    {
{"widget": {
    "debug": "on",
    "window": {
        "title": "Sample Konfabulator Widget",
        "name": "main_window",
        "width": 500,
        "height": 500,
        "stamp" : "Testing",
        "case" : 1
    },
    "image": { 
        "src": "Images/Sun.png",
        "name": "sun1",
        "hOffset": 250,
        "vOffset": 250,
        "stamp" : "Testing"
    
    },
}
}

You can use a regex in JSONPath. See https://stackoverflow.com/questions/28954720/jsonpath-expression-to-filter-using-regex — flup, Mar 11 '21 at 19:48
Unfortunately the path is not fixed. Sometimes it can appear in nested elements of jsons. — Bounty Collector, Mar 11 '21 at 19:52

ETO · Accepted Answer · 2021-03-11T20:21:48.410

1

You can try this:

String json = "<your-json-here>";
String newValue = "Testing";
String newJson = s.replaceAll("\"stamp\"\\s*:\\s*\"(.*)\"", String.format("\"stamp\" : \"%s\"", newValue));

or even something like this:

String s2 = s.replaceAll("(?<=\"stamp\")\\s*:\\s*\"(.*)(?=\")", ":\""+ newValue);

edited Mar 11 '21 at 20:21

answered Mar 11 '21 at 20:12

ETO

6,970
1
20
37

JAVA: How to find all matches of a substring in a nested JSONString and replace with some text

1 Answers1