Splunk Search

How do I use the rex field to extract the last digit from the time value in my sample data?

aramakrishnan
New Member
[2015-11-05 00:48:03,058] [/172.21.21.171:57533] [K123456789] created event: 8

How do I use rex field to extract just the last number on this, for example here, it would be 8? The log format is the same throughout, but the last number is the ID which is what I'm most interested in.

Thanks

0 Karma

ektasiwani
Communicator

Hi aramakrishnan,

You can also try this regex. \d+ will capture digit and $ (dollar sign) indicates the end of the string.

  .. | rex "(?<id>\d+$)" | ..
0 Karma

richgalloway
SplunkTrust
SplunkTrust

There are probably a few ways to do that. Here's one.

... | rex "event: (?P<ID>\d+)" | ...
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...