Splunk Search

Regex for field extraction with or without comma

magriii
Explorer

I found that the format of a sourcetype had changed some time ago.
Now I need to extract the data correctly for both cases.

 

2022-01-11 17:40:59.000, SEVERITY="123", DESCRIPTION="ooops"
2018-01-24 16:35:05 SEVERITY="112", DESCRIPTION="blabla"

 

Extraction for the first type of entries works with this regex that was build with splunk field extraction

 

^(?P<dt>[^,]+)[^"\n]*"(?P<SEVERITY>\d+)[^=\n]*="(?P<DESCRIPTION>[^"]+)

 

How can the regex be expanded to split either at "," or at the second space, if the comma is missing?

An idea is to capture always at the second space and remove the comma or split before SEVERITY and remove the comma. I didn't get either working.

You can find the regex at https://regex101.com/r/mxdAyx/1 

Thanks

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
^(?P<dt>[^ ]+ [^ ,]+)[^"\n]*"(?P<SEVERITY>\d+)[^=\n]*="(?P<DESCRIPTION>[^"]+)
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Build the Future of Agentic AI: Join the Splunk Agentic Ops Hackathon

AI is changing how teams investigate incidents, detect threats, automate workflows, and build intelligent ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...