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
Hi @umsundar2015,
Try This:
...|rex "(?<string>\S+)[\.|\-|@]\w+\.com"
thank you .
String here means the field name rit ?
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
This is not working , it displays values like
wkspfbtl18.devqa
Can you please help with other regex