Splunk Search

Field Extraction Help

carmackd
Communicator

I would like to combine extracted values into a single field. Here is my transform

[end_time_extact]
REGEX = (\d+\/\d+\/\d+)[,](\d+:\d+:\d+)
FORMAT = end_time::$2

A comma seperates yy/mm/dd from hh:mm:ss and i would like to join the two into a single field.

Suggestions? I've tried

FORMAT = end_time::$1:$2

along with many other variations

Tags (1)
0 Karma

woodcock
Esteemed Legend

Do it in reverse order like this:

[end_time_extact]
REGEX = (\d+/\d+/\d+[,]\d+:\d+:\d+)
FORMAT = end_time::$1

[split_end_time]
SOURCE_KEY=end_time
REGEX = (?<end_time_part1>\d+/\d+/\d+)[,](?<end_time_part2>\d+:\d+:\d+)
0 Karma

dwaddle
SplunkTrust
SplunkTrust

can you supply a couple of sample (redacted if necessary) events?

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...