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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...