Splunk Search

Why isn't this regex returning anything?

ashnet16
Path Finder

When running the regex below, the search doesn't return any results even though the reg ex string works well on the external regex builder I use. Help.

Here's the original string: \.(.{2,4}\s+?)

Here's the spunk search: index=*|fields file | rex field=file "(?\.(.{2,4}\s+?))" | stats count(Asset) AS "Total" by Asset | sort -Total

Tags (3)
0 Karma
1 Solution

musskopf
Builder

The first error is here:

(?.(.{2,4}s+?))

you have (? and ) at the start and end... that doesn't look right.

Also, to use the rex command, you need to use Named Capturing group in the regex, like:

.(?P<test>.+)

Where test will be the name of the field extracted.

View solution in original post

0 Karma

sves
Explorer

Hi ashnet16,

As Kristian says, we need some real data and also exactly what you try to extract from that data.

With that said, your original rex | rex field=file "(?\.(.{2,4}\s+?))" does not look right.

If you want to convert your original regular expression \.(.{2,4}\s+?) to rex, I would expect it to look something like this:

| rex field=file ".(?<fieldname>.{2,4}\s+?)"

Cheers!

#Sven Emil

0 Karma

ashnet16
Path Finder

This is the Splunk search Format for rex: (?...) (.....)equals the regular expression.

0 Karma

kristian_kolb
Ultra Champion

Hi,

please provide real data,
describe what you are trying to achieve,
use the code markup where appropriate, since this help with formatting and special characters

If you got a good answer, vote up a/o mark as answered.

/K

musskopf
Builder

The first error is here:

(?.(.{2,4}s+?))

you have (? and ) at the start and end... that doesn't look right.

Also, to use the rex command, you need to use Named Capturing group in the regex, like:

.(?P<test>.+)

Where test will be the name of the field extracted.

0 Karma

musskopf
Builder

Could you provide some of your RAW data? The content of field "file" should be enough.

0 Karma

ashnet16
Path Finder

Here is some raw data:

vcard.png
phone.png

style.css

jquery.colorbox-min.js

Thanks!!

0 Karma

musskopf
Builder

Ok, and is that a single line? or multiple entries? Also, what are you trying to extract?

0 Karma
Get Updates on the Splunk Community!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...