Get field from json using regex

Question

I have the following json document:

{  
   "videoUrl":"",
   "available":"true",
   "movie":{  
      "videoUrl":"http..."
   },
   "account":{  
      "videoUrl":"http...",
      "login":"",
      "password":""
   }
}

In this json I have a property named videoUrl, I want to get first non empty videoUrl

My regex:

("videoUrl":)("http.+")

But this regex match the following String

    "videoUrl" :"http..."},
"account" : {"videoUrl" : "http...","login" : "","password" : ""

What is my way to write Regex that will find first non empty videoUrl with it's value

(Result should be "videoUrl":"http...")

@JanOssowski Thank for response, I add , but still it's not correct — Almas Abdrazak
– Almas Abdrazak, Commented May 23, 2018 at 10:50
@B001ᛦ The problem is that I dont have i json in the begging, I parse .js script which include this json as part of the code — Almas Abdrazak
– Almas Abdrazak, Commented May 23, 2018 at 10:51
Parsing json by regex is not a good idea. Could you try jsonPath? github.com/json-path/JsonPath — dehasi
– dehasi, Commented May 23, 2018 at 10:52

xingbin · Accepted Answer · 2018-05-23 10:51:07Z

4

Add (?!,) at the end of the regex, it will make the regex stop at an , without capturing it:

public static void main(String[] args) {
    String input = "{  \n" +
            "   \"videoUrl\":\"\",\n" +
            "   \"available\":\"true\",\n" +
            "   \"movie\":{  \n" +
            "      \"videoUrl\":\"http...\"\n" +
            "   },\n" +
            "   \"account\":{  \n" +
            "      \"videoUrl\":\"http...\",\n" +
            "      \"login\":\"\",\n" +
            "      \"password\":\"\"\n" +
            "   }\n" +
            "} ";

    Pattern pattern = Pattern.compile("(\"videoUrl\":)(\"http.+\")(?!,)");
    Matcher matcher = pattern.matcher(input);
    while (matcher.find()) {
        System.out.println(matcher.group());  // "videoUrl":"http..."
    }
}

answered May 23, 2018 at 10:51

xingbin

28.4k12 gold badges62 silver badges111 bronze badges

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

Comments

Hleb · Accepted Answer · 2018-05-23 10:54:09Z

3

It will be more appropriate to use one of JSON parsers, like Gson or Jackson, instead of regex. Something like:

String jsonStr = "...";
Gson gson = new Gson();
JsonObject json = gson.fromJson(jsonStr, JsonObject.class);
String url = element.get("videoUrl").getAsString();

answered May 23, 2018 at 10:54

Hleb

7,45115 gold badges64 silver badges127 bronze badges

Collectives™ on Stack Overflow

Get field from json using regex

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related