topic Re: Extract Multiple fields in Splunk Search

Extract Multiple fields

jayeshrajvir — Tue, 15 Mar 2022 09:32:03 GMT

Sample data

[A028 : 00]
[F037 : 928323177452]
[F038 : 456137]
[F039 : 0]

The query below is working but i wanted to merge, basically i wanted to use rex field=_raw just once. How to extract multiple fields

index=au_axs_common_log sourcetype=anz_axs_auth_core_log "[A028" |rex field=_raw "(\[F039\s*:(?.*?)\])"| rex field=_raw "\[A028\s*:(?.*?)\]" |stats count by axrc,vrc

Re: Extract Multiple fields

venky1544 — Tue, 15 Mar 2022 09:48:35 GMT

hi @jayeshrajvir

try this regex \[\w+\s:\s\d+\]

just curious what are you doing with the regex coz there is no named group in the regex ??

is this a tweaked query you pasted here

Re: Extract Multiple fields

jayeshrajvir — Tue, 15 Mar 2022 11:45:40 GMT

@venky1544 It fetches/matching all the four fields. I wanted to match only two fields. Can you please share your thoughts.

Re: Extract Multiple fields

venky1544 — Tue, 15 Mar 2022 12:50:28 GMT

Hi @jayeshrajvir

PFB screenshot hope this helps