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.

ExtractText picking up the first match.

Solved Go to solution

ExtractText picking up the first match.

New Contributor

I have an event  {

"a":"avc123.abc.com",
"b":"24 - ny",
"c" : "21321kodi"
}

i would like to use extracttext to filter/extract only the "b" however, it is picking up the first match. How can I specify to extract text from field "b" only not "a" neither "c"


1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: ExtractText picking up the first match.

Super Guru

@ANMAR 

Try with this regex

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

This will extract only 24 - ny value from the given event

2 REPLIES 2
Highlighted

Re: ExtractText picking up the first match.

Super Guru

@ANMAR 

Try with this regex

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

This will extract only 24 - ny value from the given event

Re: ExtractText picking up the first match.

New Contributor

Found the solution! 
Just needed to apply the regex 

(?:"b":.\w+?)(\d+)

thanks to @Shu_ashu