How do I parse a website domain from an email address column with a coda formula?

1

Screen Shot 2021-03-05 at 7.18.53 AM
Screen Shot 2021-03-05 at 7.18.53 AM1018×334 20.5 KB

Spreadsheet analog here

Bless all Codans :crossed_swords:

2

I’m ot sure, but whatever it is, is is going to have regex.

3

Hi @David_Self ,

Two ways (at least)

  1. basically, as Excel:
thisRow.[Email].ToText().Right(thisRow.[Email].Length() - thisRow.[Email].Find("@") )
  1. with Regex (less cumbersome, to my tastes):
thisRow.[Email].RegexReplace(".*@", "")

I hope this helps.

Cheers!

1 Like
4

I was able to solve it using this formula!

    Right(thisRow.Email,Length(thisRow.Email)-Find("@",thisRow.Email ) )

Screen Shot 2021-03-05 at 7.34.49 AM
Screen Shot 2021-03-05 at 7.34.49 AM2042×620 47.3 KB

5

@David_Self or slice(thisRow.email.ToText(),Find("@",thisRow.email)+1)
but I prefer the Regexreplace from @federico

2 Likes
6

Thank you @Federico_Stefanato ! Very heplful.

1 Like
7

[emailString].ToText().Split(’@’).nth(2)

2 Likes
8

The simplest would be

Email.ToText().Split("@").Last()

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 @

Email.RegexExtract("(?<=@).*")

than replace everything up to @ inclusively with a blank string

Email.RegexReplace(".*@", "")
1 Like