Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

JSON Exraction specific key and value

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

Accepted Solutions

Super 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

Super 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

Explorer

Thanks a lot!