Splunk Search

Regex help!!!

splunker9999
Path Finder

Hi,

Can someone please help with formatting IP address or FQDN,we nee to remove [ ] in the below.

These below details are available in field name "Indicator_Value"

221[.]138[.]128[.]116
www[.]cderlearn[.]com

Thanks

Tags (1)
0 Karma

gokadroid
Motivator

Try this using mode=sed

your query to return events
| rex field=Indicator_Value mode=sed "s/\[//g
s/\]//g"

Please ensure to keep the string "s/\[//g and s/\]//g" split over two lines exactly how it appears in the query. Take care of the " (double quotes) to be same as it appears in the query.

0 Karma

twinspop
Influencer
... | eval newfield=replace(Indicator_Value,"[\[\]]","")
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Fuel Your Journey: What’s Waiting for You at the .conf26 Acceleration Station

Navigating the show floor at .conf26 isn't just about keynotes and technical breakout sessions; it's also ...

Join the Final Session of the Data Management & Federation Bootcamp Series

Over the past three sessions of the Data Management & Federation Bootcamp Series, we've explored how to build ...

From Data to Insight: Announcing the Winners of the Splunk Dashboard Contest

Hi Splunkers, First off, thank you to everyone who participated in our very first From Data to Insight: The ...