https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438928#M124898 <P>@pgadhari,</P> <P>Try</P> <PRE><CODE>Your current search | rex field=Rack "Rack-(?&lt;_RackNo&gt;\d+)"| sort _RackNo </CODE></PRE> Mon, 24 Jun 2019 11:18:58 GMT renjith_nair 2019-06-24T11:18:58Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438927#M124897 <P>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 :</P> <PRE><CODE>Rack-1 Rack-10 Rack-2 ... ... Rack-9 </CODE></PRE> <P>I want to show the values as : This is the requirement ?</P> <PRE><CODE>Rack-1 Rack-2 Rack-3 ... ... Rack-10 </CODE></PRE> <P>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 ? </P> <P>Thanks<BR /> PG</P> Mon, 24 Jun 2019 10:59:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438927#M124897 pgadhari 2019-06-24T10:59:37Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438928#M124898 <P>@pgadhari,</P> <P>Try</P> <PRE><CODE>Your current search | rex field=Rack "Rack-(?&lt;_RackNo&gt;\d+)"| sort _RackNo </CODE></PRE> Mon, 24 Jun 2019 11:18:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438928#M124898 renjith_nair 2019-06-24T11:18:58Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438929#M124899 <P>Hi @pgadhari,</P> <P>You can use <A href="https://docs.splunk.com/Documentation/Splunk/7.3.0/SearchReference/MultivalueEvalFunctions#mvsort(X)">mvsort</A> eval function like:</P> <PRE><CODE>| eval Rack=mvsort(Rack) </CODE></PRE> Mon, 24 Jun 2019 12:24:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438929#M124899 harshpatel 2019-06-24T12:24:42Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438930#M124900 <P>I will check this and revert. Thanks.</P> Wed, 26 Jun 2019 08:12:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438930#M124900 pgadhari 2019-06-26T08:12:42Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438931#M124901 <P>I will check this and revert. Thanks.</P> Wed, 26 Jun 2019 08:12:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438931#M124901 pgadhari 2019-06-26T08:12:50Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438932#M124902 <P>Thanks. This is working.</P> Sun, 30 Jun 2019 05:05:16 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438932#M124902 pgadhari 2019-06-30T05:05:16Z https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438933#M124903 <P>This also works. Hence, upvoting the post. Thanks for your reply too.</P> Sun, 30 Jun 2019 05:13:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sort-field-values-alphanumerically/m-p/438933#M124903 pgadhari 2019-06-30T05:13:47Z