Splunk Search

Count by start of string

kooojo
Engager

I have an query that

index ="main" |stats count by Text |sort -count | table count Text

results:

countText
10dog fish
20   dog cat

        

 

How can I change the compare that compare first X chars into Text , for example first 4 chars , so "dog fish" and "dog cat" will be 1 line?

 

countText
30dog .....

 

 

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
index ="main" |eval Text=substr(Text,1,4)|stats count by Text |sort -count | table count Text

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
index ="main" |eval Text=substr(Text,1,4)|stats count by Text |sort -count | table count Text
0 Karma

kooojo
Engager

And how can I add "..." as a suffix ?

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

update Text eval

|eval Text=substr(Text,1,4)."...."

 

0 Karma
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...