It would be easier to deail with emails if you put them into their own fields instead of embedding them in your notes field.
You also are referring to multiple emails--suggesting that there is an unknown number of email addresses in the field. In what form do you want to see that parsed list of email addresses? They could be entered via script into a set of related records or into a single text field separated by returns or the delimiter needed for your email program such as a semi-colon.
Both a looping script or a recursive function can return a list of emails from your text field.
Do you have FileMaker Advanced?
Yeah, I'm working in FM Pro Advanced. I have a notes field that users have unfortunately used to enter Contact attributes including emails. I made an email field and I would like to Replace Field Contents using a calculation that will extract email addresses from the Notes field. There are about 2,000 records. The vast majority of them have 1 email address... Some have 2. I'd actually like to track emails in a separate table. But first I have to extract them. I'm trying to use Replace Field Contents with an expression like this:Case (PatternCount (Contacts::ContactAttributes ; "@") ≥ 1 ;Middle (Contacts::ContactAttributes ; Position ( Contacts::ContactAttributes ; "@" ; 1 ; 1 ) -1 ; 15)&"@"&Middle ( Contacts::ContactAttributes ; Position ( Contacts::ContactAttributes ; "@" ; 1 ; 1) +1 ; 15)Only I can't hard code the 15, because I need to stop at the leading and ending spaces. Plus the above expression gives me too many @ signs. Maybe I need to do this via script or a recursive function, as you suggested. Any more advice? Thanks!!!
Take a look at the Brian Dunning site for custom functions. There's one called Parse that may work and there could be others. You could set up a looping script that parses out one email at a time and then uses the parsed email to create a new related record.