Bless all Codans
I’m ot sure, but whatever it is, is is going to have regex.
Hi @David_Self ,
Two ways (at least)
- basically, as Excel:
thisRow.[Email].ToText().Right(thisRow.[Email].Length() - thisRow.[Email].Find("@") )
- with Regex (less cumbersome, to my tastes):
I hope this helps.
I was able to solve it using this formula!
Right(thisRow.Email,Length(thisRow.Email)-Find("@",thisRow.Email ) )
@David_Self or slice(thisRow.email.ToText(),Find("@",thisRow.email)+1)
but I prefer the Regexreplace from @federico
Thank you @Federico_Stefanato ! Very heplful.
The simplest would be
No need for regex in this case, although generally speaking whenever you need to split, match, or extract a substring according to some pattern (e.g. “everything after @” is also a pattern), that’s what regular expressions are for. It’s too bad though that
RegexExtract() is still an experimental formula. It’s more logical to extract everything after @
than replace everything up to @ inclusively with a blank string