Extract email addresses from large string

[sal88]

Hi all

Is there a way that SM can (quickly) extract email addresses from a large text variable?

Thanks

[Lee Smith]

See if one of the Custom Functions available at Brian Dunning’s site will do it for you.

http://www.briandunning.com/filemaker-custom-functions/recentlist.php

Just search for email and you will get plenty of hits.

 

Lee

[john renfrew]

what is it wrapped in?? are there more than 1?

[sal88]

The data in question is a single field (of around 10,000 records). Each field is a chat log, each line of chat has an email address in. Each field would have around ten email addresses. Half of the email addresses are surrounded by '<' and '>'. If required then just extracting anything between these two symbols would suffice.

Custom functions just crash unfortunately as there's too much data.

Just realised that my sql command (both native FM and SM) which is supposed to populate the variable isn't even able to do it. It seems to be a problem with the number of records - any ideas on the limitations?

Edited February 14, 2016 by sal88

[john renfrew]

you are going to need to post some example really...

I suggest setting a variable by looping over records, FileMaker is good at that... but it depends what you want as the result.

Rather than build a massive text block, extract each record as you go and build the answer as you go...

But then the optimisation from MasterList on modular filemaker will also help by being smarter about how to create the result 

[sal88]

That sounds like the sensible option. What MasterList are you referring to though? Do you mean MasterDetail?