Splunk Search

How to write rex to extract string?

Edwin1471
Path Finder

Hi,

REX command rex mode=sed to remove quotation marks and numbers inside of them

 

OUTPUT file "19214132.IKU" copied to output directory

OUTPUT file "19315133.IKU" copied to output directory

OUTPUT file "19416134.IKU" copied to output directory

....

 

Desired result ->   OUTPUT file .IKU copied to output directory

 

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| rex mode=sed "s/(?<q1>\"\d+)(?<l1>\.[^\"]+)(?<q2>\")/\2/g"

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

What have you tried so far?

---
If this reply helps you, Karma would be appreciated.
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex mode=sed "s/(?<q1>\"\d+)(?<l1>\.[^\"]+)(?<q2>\")/\2/g"
Get Updates on the Splunk Community!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...