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

[georgemak]

 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?

[ITWhisperer · Accepted solution]

| 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]

Thank you!