Jump to content

Extract email addresses from large string


sal88
 Share

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

Recommended Posts

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 by sal88
Link to comment
Share on other sites

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 

Link to comment
Share on other sites

This topic is 2330 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
 Share

×
×
  • Create New...

Important Information

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