Splunk Search

How to sort field values alphanumerically?

pgadhari
Builder

I have a field called Rack which has the values as Rack-1 Rack-2 Rack-3....Rack-10. When I do sort on Rack field, it shows the values like below :

Rack-1
Rack-10
Rack-2
...
...
Rack-9

I want to show the values as : This is the requirement ?

Rack-1
Rack-2
Rack-3
...
...
Rack-10

By default, sort is showing Rack-10 after Rack-1 and then so on. How do I sort it alphanumeric to show the values as required above ?

Thanks
PG

0 Karma
1 Solution

renjith_nair
Legend

@pgadhari,

Try

Your current search | rex field=Rack "Rack-(?<_RackNo>\d+)"| sort _RackNo
---
What goes around comes around. If it helps, hit it with Karma :slightly_smiling_face:

View solution in original post

0 Karma

harshpatel
Contributor

Hi @pgadhari,

You can use mvsort eval function like:

| eval Rack=mvsort(Rack)

pgadhari
Builder

I will check this and revert. Thanks.

0 Karma

pgadhari
Builder

This also works. Hence, upvoting the post. Thanks for your reply too.

0 Karma

renjith_nair
Legend

@pgadhari,

Try

Your current search | rex field=Rack "Rack-(?<_RackNo>\d+)"| sort _RackNo
---
What goes around comes around. If it helps, hit it with Karma :slightly_smiling_face:
0 Karma

pgadhari
Builder

Thanks. This is working.

0 Karma

pgadhari
Builder

I will check this and revert. Thanks.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...