Splunk Search

makin the keyword case in-sensitive

abhayneilam
Contributor

Hi,
My report is getting generated as :

Keyword No_of_occurance
Mumbai 2
kolkata 2
DELhi 1
delhi 3

but my output should be like :

Keyword No_of_occurance
Mumbai 2
kolkata 2
delhi 4

because "delhi" and "DELhi" both are same keyword but occurance is 4

Please help me to achieve this

Thanks
Abhay

0 Karma
1 Solution

dshpritz
SplunkTrust
SplunkTrust

Hey Abhay,

You wouldn't really make it case insensitive, as much as normalize the case of the data. To do that you would do something like:

myfunsearch | eval Keyword = eval lower(Keyword) | stats count by Keyword

HTH,

Dave

View solution in original post

0 Karma

dshpritz
SplunkTrust
SplunkTrust

Hey Abhay,

You wouldn't really make it case insensitive, as much as normalize the case of the data. To do that you would do something like:

myfunsearch | eval Keyword = eval lower(Keyword) | stats count by Keyword

HTH,

Dave

0 Karma

abhayneilam
Contributor

Many Many thanks for this 🙂

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...