Extract field from Filepath

teco_akelly — Fri, 04 Jun 2021 00:49:25 GMT

I've got a number of files coming from directories similar to this....

C:\File Transfer\Relay Files\8Series_files\WB-CWP\WB_CWP8_869\evt.txt

I'd like to extract the WB_CWP8_869 and create it as a searchable field. The filepath always looks like this.... the section before the field I want varies....

But the beginning (C:\File Transfer\Relay Files\8Series_files\) and the end (evt.txt) is always the same.

Re: Extract field from Filepath

gcusello — Fri, 04 Jun 2021 06:27:43 GMT

Hi @teco_akelly,

if you're sure that the beginning and the end of your file path is always the same, you can use a regex like this:

C:\\File Transfer\\Relay Files\\8Series_files\\(?<your_field>[^\\]+)\\WB_CWP8_869\\evt\.txt

that you can test at https://regex101.com/r/NXHwWz/1

Ciao.

Giuseppe

topic Re: Extract field from Filepath in Splunk Search

Extract field from Filepath

Re: Extract field from Filepath