Splunk Search

Extract Multiple fields

jayeshrajvir
Explorer

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

Labels (1)
Tags (1)
0 Karma

jayeshrajvir
Explorer

jayeshrajvir_0-1647344653392.png

 

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

0 Karma

venky1544
Builder

Hi @jayeshrajvir 

PFB screenshot hope this helps 

| makeresults |eval new = "[A028 : 00]"
|append [|makeresults |eval new="[F037 : 928323177452]"]
|append [|makeresults |eval new="[F038 : 456137]"]
|append [|makeresults |eval new="[F039 : 0]"]
|rex field=new "(\[A028|\[F038)\s:\s(?<num>\d+)\]"

 

venky1544_0-1647348590034.png

 

0 Karma

venky1544
Builder

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 

0 Karma
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...