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 App for Anomaly Detection End of Life Announcment

Q: What is happening to the Splunk App for Anomaly Detection?A: Splunk is officially announcing the ...

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...