Splunk Search

How to extract the string which is between the two different special characters using regex

SureshkumarD
Explorer

Hi Team,

I need to extract the string which is between the two different special characters using regex. Could you please assist on this? Thank you. Here is the string below where I need to extract the string provisionById which is between the semicolon and period charcter.

Method End: com.bi.gb.rest.endpoint.PolicyAdminEndPoint.provisionById;  Execution Time: 7

Labels (1)
0 Karma
1 Solution

dtburrows3
Builder

This line works for this specific example 

| rex field=_raw "\.(?<extacted_fieldname_here>\w+);"


Assuming that your targeted extraction field always lies between the period and semi-colon I think it should do it.

dtburrows3_0-1718055318436.png

the "\w+" could potentially need to be change depending on what the characters are between the 2 special characters. But for this example it looks to be camelCase so \w+ should work.

 

View solution in original post

dtburrows3
Builder

This line works for this specific example 

| rex field=_raw "\.(?<extacted_fieldname_here>\w+);"


Assuming that your targeted extraction field always lies between the period and semi-colon I think it should do it.

dtburrows3_0-1718055318436.png

the "\w+" could potentially need to be change depending on what the characters are between the 2 special characters. But for this example it looks to be camelCase so \w+ should work.

 

SureshkumarD
Explorer

Hi @dtburrows3 ,

Thank you for your prompt response and it worked. Really appreciate your assistance.

0 Karma
Get Updates on the Splunk Community!

Get Operational Insights Quickly with Natural Language on the Splunk Platform

In today’s fast-paced digital world, turning data into actionable insights is essential for success. With ...

What’s New in Splunk Observability Cloud – June 2025

What’s New in Splunk Observability Cloud – June 2025 We are excited to announce the latest enhancements to ...

Almost Too Eventful Assurance: Part 2

Work While You SleepBefore you can rely on any autonomous remediation measures, you need to close the loop ...