Extract Email Address (gmail)

[Victor_Grant]

I’m trying to extract emails (name@gmail.com)from a notes field.

The format is uniform “name@gmail.com”

But I can’t figure out a fomula to extract them

There is a “space” before the name and "space after the “.com”

[Victor_Grant]

Opps Sorry for this but it seems not to be pulling in the “gmail.com” of the email addresses… Am i missing something?

[Victor_Grant]

Or is it just easier to add that part in a different field?

[Bill_French]

Victor_Grant:

it seems not to be pulling in the “gmail.com” of the email addresses…

This is one of the Notes texts I tested with:

vdjh bill.french@gmail.com hjfv jhd vjh

This is the outcome from analyzing that row:

bill.french@gmail.com

It appears that it is performing the correct entity extraction at least in terms of this collection of tests.

[Justin_Barrett]

Here’s another way to tackle it:

TRIM(MID(SUBSTITUTE({Test string}, " ", REPT(" ", 30)), FIND("@", SUBSTITUTE({Test string}, " ", REPT(" ", 30))) - 30, 60))

[Bill_French]

@Justin_Barrett,

That looks far simpler. What is the purpose of the 30 and 60 values in the formula?

[Justin_Barrett]

I’m replacing each space with 30 spaces, grabbing a chunk of the resulting larger string that begins 30 characters before the @—which is guaranteed to be somewhere the mega-space block just before the email address—and is 60 characters long—which is mostly guaranteed to be in the mega-space block after the address—then trimming the extra spaces off the ends.