Link to home
Start Free TrialLog in
Avatar of aescribens
aescribens

asked on

Parsing and Extracting Value from String

Hello Experts,

I need to extract only the Email portion from the following string:  John <jdoe@gmail.com>

I believe you use ReFind and Mid... But don't remember how to do it.

Thanks,
Anthony
Avatar of plusone3055
plusone3055
Flag of United States of America image

Avatar of aescribens
aescribens

ASKER

I followed the accepted answer and tried replacing the "(" ")" with "<" ">" and it didn't work...

#listfirst(listlast(str,"<"),">")#

Sorry, but would you please provide me with the code I need the execute?  I don't know why I'm struggling so much with this.  Thanks,
ASKER CERTIFIED SOLUTION
Avatar of gdemaria
gdemaria
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It was my mistake... I was incorrectly setting up the string value.  :)  Yes, your code is working.

Thanks!
then you should award the points to the person that first answered not the second