Skip to content

Instantly share code, notes, and snippets.

@andrewpmiller
Created October 4, 2018 12:48
Show Gist options
  • Save andrewpmiller/af20adf0fd80eea8c08e5a391d2c61a7 to your computer and use it in GitHub Desktop.
Save andrewpmiller/af20adf0fd80eea8c08e5a391d2c61a7 to your computer and use it in GitHub Desktop.
FMPro formula to extract the domain name from an email address
  1. Assumes a text field called Email
  2. Create a Calculation field
  3. Use this formula to calculate a text result:
Middle ( 
Email ; 
Position ( Email ; "@" ; 1 ; 1 ) + 1 ; 
Length (Email) - Position ( Email ; "@" ; 1 ; 1 ) + 1
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment