Splunk Search

how to extract fields using regex

umsundar2015
Path Finder

I have the below values in a field ,

Sadf123.dfd.com
er-md-kt-mgmt.com
feb-fe345@tbm.com

I need to extract the values like below ,
Sadf123
er-md-kt
feb-fe345

Can anyone help me to extract this

Tags (2)
0 Karma

493669
Super Champion

Hi @umsundar2015,
Try This:

...|rex "(?<string>\S+)[\.|\-|@]\w+\.com"
0 Karma

umsundar2015
Path Finder

thank you .

String here means the field name rit ?

0 Karma

493669
Super Champion

string is the field name to be extracted...
here I assume that before your .com you need to extract till any special characters(like . or - or @) comes...
Please provide your raw data where it wont work
have a look at regex101 which is helpful site for trial https://regex101.com/r/088pwQ/1

0 Karma

umsundar2015
Path Finder

This is not working , it displays values like
wkspfbtl18.devqa

Can you please help with other regex

0 Karma
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!

Unlocking Unified Insights: New Gigamon Federated Search App for Splunk

In today’s data-heavy environment, organizations are caught in a data distribution dilemma. As data volumes ...

GA: New Data Management App in Splunk Platform

Streamlining Data Management: Introducing a unified experience in Splunk Managing data at scale shouldn’t feel ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...