Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Extract email addresses from large string

sal88
in ScriptMaster by 360 Works

Featured Replies

Hi all

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


Thanks

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

  • Author

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

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 

  • Author

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

Create an account or sign in to comment

https://fmforums.com/topic/99097-extract-email-addresses-from-large-string/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.