Splunk Search

How to show fields that contain one or more camelCase strings?

rms_rms
Explorer

Show if field "subject" contains one or more camel case strings like:

LuckyChance to Receive a FREE IpadPro! ClaimNow!

I'm having a hard time creating a regex for this.

Please help.

 

Thank you.

 

Labels (1)
Tags (1)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust
| eval isCamelCase=if(match(subject, "([A-Z]([a-z0-9]+)){2,}"), 1, 0)

that will look for two or more capitalised words, which are followed by one or more lower case/numeric values

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

Very simple regex looks for 1 capital followed by a lower case.

Is that enough?

| eval isCamelCase=if(match(subject, "[A-Z][a-z]"), 1, 0)
0 Karma

rms_rms
Explorer

Unfortunately, it's detecting subjects which have somewhat valid capitalization.

1Your Monday afternoon trip with Uber
1

Our SUPER Club Benefit

0 I RECORDED YOU!

 

I would like to identify subjects that contains concatenated strings like "LuckyChance" and "DysonVacuum" from the sample below:

LuckyChance to Receive a FREE DysonVacuum!

 

Thank you.

Tags (2)
0 Karma

bowesmana
SplunkTrust
SplunkTrust
| eval isCamelCase=if(match(subject, "([A-Z]([a-z0-9]+)){2,}"), 1, 0)

that will look for two or more capitalised words, which are followed by one or more lower case/numeric values

rms_rms
Explorer

This works!

Thank you.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk on November 6 at 11AM PT, and empower your SOC to reach new heights! Duration: ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...