Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

JSON Exraction specific key and value

Solved Go to solution
Highlighted

JSON Exraction specific key and value

New Contributor

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

Re: JSON Exraction specific key and value

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

2 REPLIES 2

Re: JSON Exraction specific key and value

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

Re: JSON Exraction specific key and value

New Contributor

Thanks a lot! 

Don't have an account?
Coming from Hortonworks? Activate your account here