topic Re: How to extract a string using regex? in Splunk Search

How to extract a string using regex?

AbubakarShahid — Fri, 23 Mar 2018 16:07:30 GMT

Hello all,

I am trying to write a regex to extract a string out an interesting field that I have already created and wanted to extract a string out by using regex.
I created a table that displays 4 different columns and from one of the column, I want to extract out "Message accepted for delivery" and put it into a new column. is there a way to do that. Much appreciate it.

Re: How to extract a string using regex?

tiagofbmm — Fri, 23 Mar 2018 16:39:29 GMT

Can you show us one sample line of your table and tell us exactly what you want to extract please?

Re: How to extract a string using regex?

skoelpin — Fri, 23 Mar 2018 16:43:53 GMT

We can't help until there is sample data to test against

Re: How to extract a string using regex?

damiensurat — Fri, 23 Mar 2018 16:49:27 GMT

You sure can. But before I get into it, here's a site that can help with your regex expression extractions:
https://regex101.com/
It would be better if you supplied the whole string in the field containing "Message accepted for delivery", as well as your search, as I can better answer this question with those provided, but this rex should do the trick:

yoursearch | rex field=fieldContainingYourMessage "(?<Message1>Message accepted for delivery)"

What the search above will do will provide you with a new field called Message1 and the content/values will be "Message accepted for delivery"