Splunk Search

How can I convert a text string to a number?

ptur
Path Finder

I have a field that contains a text string representing time ("900 ms" for example - all values are in milliseconds) is there a way to extract a number, so i can find values "greater than" or "smaller than"?

0 Karma
1 Solution

493669
Super Champion

try this

...|rex field=<fieldname> "(?<ms>\d+)"

include your fieldname here

View solution in original post

0 Karma

TISKAR
Builder

Hello,

Can you try this please:

|makeresults | eval field="900 ms" | rex field=field "(?<field>\d+)"

Regards

0 Karma

493669
Super Champion

try this

...|rex field=<fieldname> "(?<ms>\d+)"

include your fieldname here

0 Karma

ptur
Path Finder

thanks !!!

0 Karma
Get Updates on the Splunk Community!

New Dates, New City: Save the Date for .conf25!

Wake up, babe! New .conf25 dates AND location just dropped!! That's right, this year, .conf25 is taking place ...

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...