Splunk Search

Reg Expression to find middle charatcter

ashokapex
Explorer

Hi ,
I am new in splunk, i need to find some letter from text using Reg: ex.
how i can do.

i have to find text after Channel , (BLACKROCK) only i dont want to find other text
and this text can chnage, i only know after channel and before trader??

i am using this , but taking every thing after BlackRock ,rex field=_raw "channel (?.*)"

channel BLACKROCK** trader null, new version is 4 new status is Timed Out (Client)
Tags (1)
0 Karma
1 Solution

somesoni2
Revered Legend

Try something like this

your base search | rex "channel (?<YourField>\w+)"

OR

your base search | rex "channel (?<YourField>\S+)"

OR

your base search | rex "channel (?<YourField>[^\s]+)"

Update
For multiple fields (assuming status is complete string from "new status is " to the end)

   your base search | rex "channel (?<YourField>\S+)([^,]+), new version is (?<version>\S+) new status is (?<status>.*)"

View solution in original post

0 Karma

somesoni2
Revered Legend

Try something like this

your base search | rex "channel (?<YourField>\w+)"

OR

your base search | rex "channel (?<YourField>\S+)"

OR

your base search | rex "channel (?<YourField>[^\s]+)"

Update
For multiple fields (assuming status is complete string from "new status is " to the end)

   your base search | rex "channel (?<YourField>\S+)([^,]+), new version is (?<version>\S+) new status is (?<status>.*)"
0 Karma

ashokapex
Explorer

Nice cool, how we can do multiple field.

rex field=_raw "channel (?\S+) new status is (?.*) "

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

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 ...