Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

JSON Exraction specific key and value

avatar
Explorer

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. 

1 ACCEPTED SOLUTION

avatar
Master Guru

@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

View solution in original post

2 REPLIES 2

avatar
Master Guru

@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

avatar
Explorer

Thanks a lot!