Splunk Search

How to replace random substring in path?

SplunkNewbie100
New Member

Hi all,

 

I  want to replace random substrings in path:

C:\Users\sjfklsj\Appdata\.... -> C:\Users\---\Appdata\....

C:\Users\aegdfedg\Appdata\.... -> C:\Users\---\Appdata\....

etc..

So I want to remove the random username from the path.
Thank you!

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex mode=sed "s/(?<x>Users\\\)(?<random>[^\\\]+)/\\1---/g"
0 Karma

yuanliu
SplunkTrust
SplunkTrust

A slightly more semantic approach could be

| eval path = split(path, "\\")
| eval path = mvjoin(mvappend(mvindex(path, 0, 1), "---", mvindex(path, 3, -1)), "\\")
Tags (2)
0 Karma
Get Updates on the Splunk Community!

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...

Enhance Your Splunk App Development: New Tools & Support

UCC FrameworkAdd-on Builder has been around for quite some time. It helps build Splunk apps faster, but it ...