Splunk Search

Regex for transforms.conf for splitting string

bowesmana
SplunkTrust
SplunkTrust

Been trying hundreds of different ways to get there,

I have a REGEX in transforms.conf that creates Timers, Values fields. These contain comma separated numbers, e.g.

63,218

21521,1,0

I am trying to turn these in to mv lists with other transforms, e.g.

[toserver-instr-timers]

SOURCE_KEY = Timers

REGEX = (?[^,]*),

MV_ADD = true

This works, but does not get the last timer/value, so th T array has just 63 and the V array has only 21521 and 1

How do I get the regex to make the last non , terminated field into an array elemenet.

0 Karma

Paolo_Prigione
Builder

Have you tried to turn the last comma into optional?

REGEX= (?<t>[^,]*),?
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!

Free Professional Services for .conf26 Attendees

This year at .conf26, we are doing something a little different. We are bringing the best minds from ...

Defend at Machine Speed: Your Guide to Security Sessions at .conf26

Splunk .conf26   With threats moving at machine speed and attack surfaces expanding across hybrid ...

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...