Hello!
I am looking for assistance in retrieving ONLY the email address from the output below.
i:0#.f|membership|jane.doe@company.com;#Jane Doe
Hello!
I am looking for assistance in retrieving ONLY the email address from the output below.
i:0#.f|membership|jane.doe@company.com;#Jane Doe
Hi
You should be able to use Regex to do something like this. A quick example would be an extract regex using (?<=\|.*\|).*@.*(?=;)
This does assume that all usernames will be a similar form though.
Hi and thanks for your response! So I attempted the your recommendation but not able to get this to work… am I incorrect somewhere?
replace(eForm].[Requested By],"(?<=\|.*\|).*@.*(?=;)")
Try the expression below:
replace(replace([Form].[Requested By],"i:0#.f[|]membership[|]",""),";(.*)","")
I was totally missing a lot to include, good to know! Thanks so much
Glad it helped
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.