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
Solved
Extract email address
Best answer by bamaeric
Try the expression below:
replace(replace([Form].[Requested By],"i:0#.f[|]membership[|]",""),";(.*)","")
- Nintex Employee
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([Form].[Requested By],"(?<=\|.*\|).*@.*(?=;)")
+14Try the expression below:
replace(replace([Form].[Requested By],"i:0#.f[|]membership[|]",""),";(.*)","")
Check out my blog at https://www.techrhodes.com
I was totally missing a lot to include, good to know! Thanks so much
+14Glad it helped
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.