Strip out domain name from an email address

[SachinC]

Hi,

I have a field with email addresses. I wish to strip out the domain name only, i.e. values from after the @ symbol.

Please advise?
Thanks.

[Seth_C_Bauer · Accepted solution]

@SachinC A "click" approach would be to go to "Edit Queries" -> Split Column -> Select "By Delimiter" -> Choose "Custom" in drop down -> input the "@" -> select "At each occurence of the delimiter" -> OK

This splits the column and you can delete the column you no longer need.

[Greg_Deckler · Accepted solution]

Try this:

Column = MID([Email],FIND("@",[Email])+1,LEN([Email])-FIND("@",[Email]))

[shoeb1359]

Hi Greg,

I want to pick name only from email id. (text before "@")

please help i tried but it's not working

Dynamic Greeting =
var x =FORMAT(USERPRINCIPALNAME(),"")
return
MID(x,FIND("@",x),LEN(x)-FIND("@",x))

[Seth_C_Bauer · Accepted solution]

@SachinC A "click" approach would be to go to "Edit Queries" -> Split Column -> Select "By Delimiter" -> Choose "Custom" in drop down -> input the "@" -> select "At each occurence of the delimiter" -> OK

This splits the column and you can delete the column you no longer need.

[Anonymous]

top man.

really good solution