topic Re: How can I convert a text string to a number? in Splunk Search

How can I convert a text string to a number?

ptur — Fri, 25 May 2018 13:06:30 GMT

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"?

Re: How can I convert a text string to a number?

493669 — Fri, 25 May 2018 13:16:38 GMT

try this

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

include your fieldname here

Re: How can I convert a text string to a number?

TISKAR — Fri, 25 May 2018 13:29:10 GMT

Hello,

Can you try this please:

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

Regards

Re: How can I convert a text string to a number?

ptur — Fri, 25 May 2018 13:33:05 GMT

thanks !!!