Splunk Search

Generated pattern (regex)

kailun92
Communicator

I need to extract both of the words, is there anyone that knows how ? I have used this
(?i)summary : (?P<FIELDNAME>[\w\.]+)
but it extracts only the word Mostly.

summary : Mostly Cloudy

1 Solution

kailun92
Communicator

I tried this expression and it work. Btw thanks for your help ! 😃

(?i)Summary : (?P.+)\n

View solution in original post

kailun92
Communicator

I tried this expression and it work. Btw thanks for your help ! 😃

(?i)Summary : (?P.+)\n

peter_krammer
Communicator
(?<field_name>\S+)\s+:\s+(?<field_value>.+)

Be careful about the cases of 's', because '\s' has a different meaning than '\S'.

0 Karma

kailun92
Communicator

see my comments down, I cannot post codes in here.

0 Karma

peter_krammer
Communicator

Well thats quite a different usecase, thanI would have guessed from your initial question. I updated my answer to extract the field_name ("summary") and the field_value ("Mostly Cloudy") seperatly.

But maybe you also want to take a look at handling multiline events.

0 Karma

kailun92
Communicator

I am using 5.0.2. Btw it worked but my data is inputed this way(below), it extracts this

FIELDNAME
Mostly Cloudy
temperature
Foggy
temperature
lastword
temperature

(Splunk reads my data every 5 minutes)
time : 1371715104
visibility : 0.67
windBearing : 260
windSpeed : 9.41
psiAverage : 182
cloudCover : 0.61
dewPoint : 65.58
humidity : 0.39
icon : fog
ozone : 267.04
precipIntensity : 0
pressure : 1005.64
summary : Foggy
temperature : 94.49

0 Karma

peter_krammer
Communicator

Now I changed it, so the inner caption group is named as well, even if it is not needed on my test instance (5.0.1).

kailun, which splunk version do you use?

0 Karma

kailun92
Communicator

Invalid regex: no named extraction at position 27 (i.e., ">([\w.]+..."). Expected "(?Ppattern)"

0 Karma

peter_krammer
Communicator

The questionmark in the inner caption group was producing a problem, I edited my answer to my tested solution.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...