Splunk Search

Rex syntax to define result data

jsturgeon
New Member

Hello, 
I am looking to clean up the result data from a Splunk query.
How do I remove all the text prior to the user name at the end of the line?

Server1234.prod.outlook.com/Microsoft Exchange Hosted Organizations/MyOrg.onmicrosoft.com/Smith, Joe

I want the results to just return "Smith, Joe"

thoughts?

Labels (1)
Tags (1)
0 Karma

efika
Communicator
| makeresults 1 
| eval _raw="Server1234.prod.outlook.com/Microsoft Exchange Hosted Organizations/MyOrg.onmicrosoft.com/Smith, Joe" 
| rex mode=sed "s/.*\///g" 
| table _raw
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...