Splunk Search

count of character in field

EricPartington
Communicator

how would I count the number of occurances of a character or symbol in an extracted field and display that as a seperate field?

for instance counting the number fields passed in a POST message? (delimited by 😃

i have looked at rex, mvcount and stats but so far havent come up with a solution to do it from a search.

Any ideas?

Tags (3)
0 Karma
1 Solution

sideview
SplunkTrust
SplunkTrust

there's probably more than way to do it with the eval command.

http://www.splunk.com/base/Documentation/latest/SearchReference/CommonEvalFunctions

Here's one, if you have a field called 'postPayload':

<your search> | eval numArgs = mvcount(split(postPayload,"="))-1

View solution in original post

mw
Splunk Employee
Splunk Employee

How about something like this:

sourcetype=access_combined | eval chars=mvcount(split(uri, "=")) - 1 | table uri, chars
0 Karma

sideview
SplunkTrust
SplunkTrust

there's probably more than way to do it with the eval command.

http://www.splunk.com/base/Documentation/latest/SearchReference/CommonEvalFunctions

Here's one, if you have a field called 'postPayload':

<your search> | eval numArgs = mvcount(split(postPayload,"="))-1
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...