Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Extracting email addresses from a text


This topic is 6553 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm trying to find a good way to extract email addresses from a text and use this addresses to find records in other DB files and do some other automated stuff based on the found sets.

Problem is, an email adress can come along in a variety of ways, e.g. , or "[email protected]" etc...

So far I focused on the version including "<>" which happens to the addresses in the header in Entourage, if you forward it and then copy and paste the whole text into a FileMaker text field.

Question 1:

Is there a way (like PatternCount) to count all words that include "@" AND "<" to get the total number of valid emails in the text???

Question 2:

Is there a way to use the "@" and extract all letters to the left and right of it until you get to the next blank?

The coolest solution of course would be to extract all words inluding "@" and convert them into valid emails...

Any ideas???

Stefan

Link to comment
Share on other sites

Hi Stevie

even if you haven't a dev version of FileMaker, you can play with that custom function...

but you have to use this file to start from...

P.S.:P you can't edit or see that custom, but you can use it !

Double P.S.: to avoid problems with Italian version of FM vs American version, before to use this file, make an empty clone.

GetEmail.zip

Link to comment
Share on other sites

This topic is 6553 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.