Splunk Search

How to search a range of numbers?

n179911
New Member

In Splunk, how can I search for a range of numbers (e.g. from "Test213" to "Test220")?

I tried 'test2[13-20]" or 'test2(13-20)" but it does not work?

Any idea?

0 Karma

somesoni2
Revered Legend

The base search (before first pipe) doesn't support regular expression as filter. If you're looking for a string with range of numbers in raw data OR in a field, use regex instead, like this

your base search | regex _raw=".*Test2((1[3-9])|20).*"

OR

your base search | regex yourfield="Test2((1[3-9])|20)"

ddrillic
Ultra Champion
  basesearch 
  | eval test="Test213"
  | rex  field=test "Test(?<test_num>\d\d\d).*"

Seems to work...

0 Karma

ddrillic
Ultra Champion

A little better -

 basesearch 
| eval test="Test2130"
| rex  field=test "Test(?<test_num>(\d).*)"

sundareshr
Legend

Try this "(Test21[3456789]|220)"

0 Karma
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...