question JSON Exraction specific key and value in Support Questions

JSON Exraction specific key and value

ANMAR — Mon, 09 Sep 2019 21:40:21 GMT

how can I extracttext specific key and value from json data ?
{
"key1" : "value1",
"key2" : "value2",
"key3" : "value3",
}

I would like to apply the extraxttext on Key2 and its value only.

Re: JSON Exraction specific key and value

Shu_ashu — Tue, 10 Sep 2019 03:02:41 GMT

@ANMAR

Try with this regex

(?:\"key2\"\\s*:\\s*)(.*?),

This will extract only the value of "key2" key i.e "value2"

if you don't need quotes to be extracted then use this regex

(?:\"key2\"\\s*:\\s*)"(.*?)",

This will extract only the value of "key2" key i.e value2

Re: JSON Exraction specific key and value

ANMAR — Tue, 10 Sep 2019 14:57:47 GMT

Thanks a lot!