Hema_Latha
(Hema Latha)
January 30, 2020, 4:48am
1
Hi, Can someone help me in writing correct regex pattern to fetch only email address from the below info picked from a webpage. I want only email IDs as final output, please help me.
Name: Alberto Wynk
Email: [albertowynk@wethy.edu]
Curriculum: 2023 BU
Name: Alberto Nick
Address: Campus Box 1146
Title: University Fellow
Department: Mathematics - A&S
Email: [alberto.nick@.wethy.edu]
Name: Alberto syen
Email: [alberto.syen@wethy.edu]
Curriculum: GR
Hema_Latha
(Hema Latha)
January 30, 2020, 4:56am
3
Thank you Ashwin. As I am still learning on RegEx, can you send the full expression if possible.
Please check the image, so that I can use the expression direclty in "E-mail assign " activity. Kindly help.
AshwinS2
(Ashwin S)
January 30, 2020, 4:58am
4
Hi @Hema_Latha
Use matches activity and pass the regex pattern and string value
Thanks
Ashwin.S
nisar.nazish
(NISAR AHMED NAZISH)
January 30, 2020, 5:10am
5
Hi @Hema_Latha
Check this as @AshwinS2 said
([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})
use this pattern to extract email id from the string
Hema_Latha
(Hema Latha)
January 30, 2020, 5:15am
7
Please confirm whether am doing correctly…
Also this is the workflow created for the same.
RegexPatternCheck.xaml (5.8 KB)
check this if this what you are looking for!
you’re good!
just add this (?<=Email:).*
if you dont want [ ] you can use my sample workflow!
kirti.iyer
(Kirti Iyer)
January 30, 2020, 5:39am
11
please find the attached.
Sequence1.zip (1.6 KB)
Yoichi
(Yoichi)
January 30, 2020, 5:59am
12
Hi,
You can easily get the pattern from RegEx Builder of Matches activity as the following.
Then, the following will help you.
Note: item in for Each shoud be System.Text.RegularExpressions.Match type.
Regards,
Hema_Latha
(Hema Latha)
January 30, 2020, 6:02am
13
Yes, Pradeep. It is working, thankyou so much
1 Like
cheers @Hema_Latha
Happy learning!
system
(system)
Closed
February 2, 2020, 7:12am
16
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.