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
Highlighted

ExtractText picking up the first match.

Explorer

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

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

View solution in original post

2 REPLIES 2

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

View solution in original post

Highlighted

Re: ExtractText picking up the first match.

Explorer

Found the solution! 
Just needed to apply the regex 

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

thanks to @Shu_ashu  

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