Splunk Search

Help with Regex

shruti14
Explorer

Hi, Can someone help me with field extraction for string :

/home/mysqld/databasename/audit/audit.log

I want to extract databasename as Database to be used 

i have written regex but getting error, can someone help with correct regex:

rex field=source "\/home\/\/mysqld\//(?<Database>.*)/audit\/"

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

It would help to know what error you're getting.

The regex has too many slashes. needs explicit <>, and the slash before "audit" must be escaped.  This works with the example data.

| rex field=source "\/home\/mysqld\/(?<Database>.*)\/audit\/"

  

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It would help to know what error you're getting.

The regex has too many slashes. needs explicit <>, and the slash before "audit" must be escaped.  This works with the example data.

| rex field=source "\/home\/mysqld\/(?<Database>.*)\/audit\/"

  

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

The All New Performance Insights for Splunk

Splunk gives you amazing tools to analyze system data and make business-critical decisions, react to issues, ...

Good Sourcetype Naming

When it comes to getting data in, one of the earliest decisions made is what to use as a sourcetype. Often, ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...