Splunk Search

How to count the number of times a special character is used in a string or field

georgemak
Engager

 I have a field called "command" with the below input:

C:\windows\systems32\cmd.exe /c ""c:\program Files(x86)\Microsoft.

So I want to extract all the special characters and need to get the count of number of times a special character is used.. 

For example; I want my result to be like this :

Special character    Count

\                                       5

/                                       1

""                                      1

(                                         1

)                                          1

 

How can I get this done?

 

 

 

 

Labels (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| rex max_match=0 "(?<special>[\"\\\/\(\)])"
| stats count by special

The issue with this is that you appear to be wanting to count "" as one character - if this is what you actually intend, then you should either divide the result for this character (pair) by 2 or substitute "" for " in the original string

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| rex max_match=0 "(?<special>[\"\\\/\(\)])"
| stats count by special

The issue with this is that you appear to be wanting to count "" as one character - if this is what you actually intend, then you should either divide the result for this character (pair) by 2 or substitute "" for " in the original string

georgemak
Engager

Thank you! 

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...