makin the keyword case in-sensitive

[abhayneilam]

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

[dshpritz · Accepted solution]

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

[abhayneilam]

Many Many thanks for this 🙂