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
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...