question Re: ExtractText picking up the first match. in Support Questions

ExtractText picking up the first match.

ANMAR — Mon, 09 Sep 2019 17:14:50 GMT

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"

Re: ExtractText picking up the first match.

Shu_ashu — Tue, 10 Sep 2019 04:07:19 GMT

@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.

ANMAR — Tue, 10 Sep 2019 14:59:46 GMT

Found the solution!
Just needed to apply the regex

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

thanks to @Shu_ashu