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!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

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