topic Re: How to extract content between two strings? in Splunk Search

How to extract content between two strings?

senthamilselvan — Tue, 16 May 2017 17:22:20 GMT

Hi Team,

I have an error message coming up in Splunk like below. The required log message will come in the middle of the line and i have to extract the content which lies between SQL0911N & SQLSTATE=40001 .

********* SQL0911N  ##############.  SQLSTATE=40001

Can you please help us to write rex to extract the fields in between the 2 strings. Please let me know if need more information.

Thanks & Regards
Senthamilselvan J

Re: How to extract content between two strings?

somesoni2 — Tue, 16 May 2017 18:02:00 GMT

If those strings (SQL0911N & SQLSTATE=40001) are static/fixed, try like this for inline extraction in search

your base search | rex "SQL0911N\s*(?<YourFieldName>.+)\s*SQLSTATE=40001"

Re: How to extract content between two strings?

woodcock — Tue, 16 May 2017 19:16:48 GMT

Like this:

... | rex "SQL\d+N\s*(?<YouFieldNameHere>.+)\s*SQLSTATE=\d+"

Re: How to extract content between two strings?

senthamilselvan — Mon, 22 May 2017 09:44:07 GMT

Thank you!! As of now we are getting output excluding the key values (SQL\d+N\s & SQLSTATE=\d+). But i want to display both the key values in the error message as well. Please let me know the rex to includes the key values also.

Re: How to extract content between two strings?

woodcock — Tue, 29 Sep 2020 14:10:20 GMT

... | rex "(?SQL\d+N)\s*(?.+)\s*SQLSTATE=(?\d+)"

Re: How to extract content between two strings?

senthamilselvan — Fri, 26 May 2017 13:52:57 GMT

Hi Woodcock,

The search query is not working as expected, Still i am getting message excluding the two key values(SQL\d+N\s & SQLSTATE=\d).