Splunk Search

Check for pure numeric field values or alphanumeric

AshimaE
Explorer

I have extracted a field using regex having the name push. I now have to classify all my rows into two categories based on whether push is all numeric or contains some alphabets also. Let it be divided into classes pure and mixed and given in a field class.
Any suggestions on how to do this since the numbers involved are too huge going upto 15-20 characters.How to fill in the class field for this statement.

Tags (2)
0 Karma

niketn
Legend

Hi Ashima, you can use isnum() evaluation function. Following is run-anywhere search.

| makeresults
| eval push="TestData123"
| eval class=if(isnum(push),"numeric","alpha")

PS: Above one will treat negative and decimal numbers also as numeric.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

niketn
Legend

@AshimaE, can you please test and confirm whether the suggested change works for you?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi AshimaE,
try something like this

your_search
| rex field=push "(?<type_num>[0-9]*)"
| eval type=if(type_num=*,"Numeric","Alfanumeric")
| stats count by type

Bye.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

Index This | What goes away as soon as you talk about it?

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

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...

Getting Started with Splunk Artificial Intelligence, Insights for Nonprofits, and ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...