topic Re: regex to capture both fields as below in Getting Data In

regex to capture both fields as below

pavanbmishra — Mon, 28 Jun 2021 10:33:27 GMT

Hi SMEs,

Seeking help to capture below 2 strings (Only string1 & Only string1) as below in one regex

","category":"Only string1",

","category":"a1b2c3-Only string2",

Re: regex to capture both fields as below

ITWhisperer — Mon, 28 Jun 2021 10:49:45 GMT

| rex "\"category\":\".*(?<string>Only string\d)\""

Re: regex to capture both fields as below

pavanbmishra — Mon, 28 Jun 2021 11:06:10 GMT

Let me be more clear here

","category":"thisissomethingineedtocapture",

","category":"a1b2c3-thisissomethingialsoneedtocapture",

Here thisissomethinginnedtocapture & thisissomethingialsoneedtocapture should come in regex value. These both are strings and doesn't have any numeric value.

Re: regex to capture both fields as below

ITWhisperer — Mon, 28 Jun 2021 11:18:07 GMT

Often helps to be clearer 😀 Will this work?

| rex "\"category\":\".*?(?<string>[^\-\"]+)\""

Re: regex to capture both fields as below

kamlesh_vaghela — Mon, 28 Jun 2021 11:26:49 GMT

@pavanbmishra

Can you please try this?

YOUR_SEARCH | rex field=_raw "\"category\":\"(.*\-)?(?<category>.*)\""

My Sample Search :

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.