Splunk Search

How to write Host_regex to extract filename from the source path

deepthi5
Path Finder

Hi Team

I have file names C:\SPLUNKCEBU\rdilraanan010-4-1.ncr.com.Gi0-2.csv

from which i need host_regex to take only the name of the file ex: rdilraanan010-4-1.ncr.com.Gi0-2 No path and no extension
Right now i have got a host_regex =(?\w+-\d+-\d) like this but this extracts only till rdilraanan010-4-1 which is not my desired output

can any one help

Thanks and Regards,
Deepthi Bulusu.

Tags (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

This worked for me using your example on regex101.com

"(?<filename>[\w-\d\.]+)\.\w"
---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

This worked for me using your example on regex101.com

"(?<filename>[\w-\d\.]+)\.\w"
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...