Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I am trying to extract just the email address from a string of text, for example: Joe Blogs | Senior Advisor | Joe.bloggs@example.co.uk | pointOfContact

I have tried the StringReplacer but I'm struggling to remove everything I need to, without also removing part or all of the email as well. Any help would be appreciated, thank you.

Hi @clare42​ ,

 

Try this regex with the StringSearcher transformer.

<\w.+]+@d\w+\.\w.]+

The output should be: Joe.bloggs@example.co.uk

Hi @clare42​ ,

 

Try this regex with the StringSearcher transformer.

<\w.+]+@d\w+\.\w.]+

The output should be: Joe.bloggs@example.co.uk

Hi, thank you. It works much better, but it seems to cut the end bit off, so I end up with Joe.Bloggs@example

Hi @clare42​ ,

 

Try this regex with the StringSearcher transformer.

<\w.+]+@d\w+\.\w.]+

The output should be: Joe.bloggs@example.co.uk

Nice!

Hi, thank you. It works much better, but it seems to cut the end bit off, so I end up with Joe.Bloggs@example

Hi @clare42​ . My regular expression knowledge isn't the best, so you might want to use this regular expression that should be a safer bet in capturing email addresses. 

 

Source: https://emailregex.com/

Regex: 

(?::a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.

 

In my testing it does in fact capture the email address you provided in your example. 

parametersfme

Hi, thank you. It works much better, but it seems to cut the end bit off, so I end up with Joe.Bloggs@example

Thank you 😊

Reply


Community Stats

30,176
Posts
114,543
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.