I'm assuming the membership name is the same as the one presented in the email address. If so couldn't you use Split() to get the first entry in the email?
The email is is like belwo I think my pic is off..
I need to get to the "A27111" data.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand