topic Re: Case-insensitve sort in Splunk Search

Case-insensitve sort

atornes — Wed, 12 Sep 2012 18:09:47 GMT

Is there a way that I can sort some data alphabetically where the values are case insensitive? Currently, it sorts all lowercase values alphabetically first, then all of the capitalized values alphabetically after. I want them intermingled so a term like "cat", "Cat", "dog" or are intermingled based on another field rather than being sorted as "cat", "dog", "Cat"

Re: Case-insensitve sort

ayme — Wed, 12 Sep 2012 18:28:31 GMT

... | eval pet=lower(pet) | sort - pet

Re: Case-insensitve sort

Ayn — Wed, 12 Sep 2012 18:33:29 GMT

A somewhat ugly but working way of doing this would be to write a new hidden field with just lowercase versions of the values and then sort by this field, but show the "original" field in the results:

... | eval _sortfield=lower(yourmixedcasefield) | table yourmixedcasefield _sortfield | sort _sortfield

Re: Case-insensitve sort

helge — Sat, 14 Feb 2015 00:47:38 GMT

This should really be possible out of the box without resorting to this ugly hack.

Re: Case-insensitve sort

helge — Sat, 14 Feb 2015 01:11:21 GMT

This works, but as you mentioned it is ugly. Especially since you need to make the search even longer by removing _sortfield or it will show up in the table:
| fields - _sortfield

Re: Case-insensitve sort

Micheal_S — Thu, 07 Jul 2022 20:34:39 GMT

Ran into this yesterday and this is exactly what I needed. Thank you.