Splunk Search

Help removing strings after a certain string with Rex

harshparikhxlrd
Path Finder

I'm trying to remove characters after a certain string in my search string. I am still getting the strings after "3" appearing after. I only want a 3 to be displayed.

I only want the 3 to show up from "number of supervisor reminder memos sent:" and I want everything after the 3 to remove.

0 Karma
1 Solution

woodcock
Esteemed Legend

If you would like to get 3 characters, use this:

... | rex "Number of supervisor reminder memos sent:\s*(?<ex>.{3}?)

If you would like to get all characters up to the first character 3, use this:

... | rex "Number of supervisor reminder memos sent:\s*(?<ex>[^3]+?)

View solution in original post

woodcock
Esteemed Legend

If you would like to get 3 characters, use this:

... | rex "Number of supervisor reminder memos sent:\s*(?<ex>.{3}?)

If you would like to get all characters up to the first character 3, use this:

... | rex "Number of supervisor reminder memos sent:\s*(?<ex>[^3]+?)

nplamondon
Communicator

It looks like your post got truncated; I don't see the complete event or your results.

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...