Help me extract the string from this line

Learn Academy Feedback
, ,
1

INPUT - “Bahuguna, Gaurav [Sapient Consulting Limited]” gauravbahuguna@chevron.com

output I want - gauravbahuguna@chevron.com

2

Please use the regex expression to extract the email from a string.

Regex expression -

Regex(@"[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,6}", RegexOptions.IgnoreCase)

Regards,
Karthik Byggari

3

Use Regex

([\w.-]+)@([\w-]+)((.(\w){2,3})+)$

This is identify the email format

4

Hi @Gaurav07,

Try to use this in the assign activity…

outStr= inputStr.Split(" "c)(2)

Cheers.
Vashisht.

5

Hi @Gaurav07 ,

Try to use this in the assign activity

outstr = Right(inputStr,43)

Regards,
Gulshiyaa

1 Like
6

Main.xaml (4.5 KB)

Check this .xaml file
It works