Created on 09-09-2019 10:41 AM - last edited on 09-09-2019 02:40 PM by ask_bill_brooks
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.
Created on 09-09-2019 08:01 PM - edited 09-09-2019 08:02 PM
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
Created on 09-09-2019 08:01 PM - edited 09-09-2019 08:02 PM
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
Created 09-10-2019 07:57 AM
Thanks a lot!