Skip to main content
Nintex Community Menu Bar

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 ​@jpacheco 

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.


@brent_read ,

 

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[|]",""),";(.*)","")


@bamaeric ,

I was totally missing a lot to include, good to know! Thanks so much ​@bamaeric , this helped a lot!!!


Glad it helped ​@jpacheco !


Reply