Splunk Search

How to extract the file name from a file path using rex in a search?

twh1
Communicator

I am getting the file path in my search result. When I am displaying it in dashboard with chart, I need to only extract the file name, not the complete path.

Current output:
/app/wlprd11g/instances/csweb1020/logs/csweb1020_access.log
/app/wlprd11g/instances/csweb1021/logs/csweb1021_access.log
/app/wlprd11g/instances/csweb1022/logs/csweb1022_access.log
/app/wlprd11g/instances/csweb1023/logs/csweb1023_access.log

Desired output:
csweb1020_access.log
csweb1021_access.log
csweb1022_access.log
csweb1023_access.log

0 Karma
1 Solution

twh1
Communicator

I used substr function and got the expected result.

... | eval source=substr(source,40)

View solution in original post

0 Karma

twh1
Communicator

I used substr function and got the expected result.

... | eval source=substr(source,40)

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try this.

... | rex "(?:\/?.+\/)*(.+?)$" | ...
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...