Extract excel email address

How i can extract email address from excel using regular expression and if i have email address like emtec.com,ashling.com then i dont need to add in queue if i have email address like abc@gmail.com,abc@yahoo.com then i have to add to queue

plz anyboday help me out

Hi @Sandhya_Gajare Follow these steps:

  1. Use a ismatch activity to check that is valid mail or not.

  2. Use if condition to check if it’s a valid mail or not. If valid mail then add to queue item

Hello @Sandhya_Gajare

  1. You can use the below regex to get the email ID
System.Text.RegularExpressions.Regex.Match(YourString,"[a-zA-Z0-9+_.-]+@[a-zA-Z0-9.-]+").to String.Trim
  1. After Extract data, you can check
    YourString.Contains("@") It returns Boolean
    Id true, the data will update in the queue, Else process will skip the update queue

can you give me the code plz

Sequence.zip (1.9 KB)

download this one

i have to extract from excel sheet i have excel sheet with column name primary mail address from excel i have to extract and compaire

Okay then use for each row activity and pass the column value to input property of ismatch activity.

e.g CurrentRow(“emailColumn”).ToString to input property of ismatch

Let me send the code…
New folder (2).zip (16.0 KB)

1 Like

Kindly refer to this Xaml file, you may get some idea
Forum_MailDetect_Excel.zip (74.1 KB)


1 Like

Hello @Sandhya_Gajare How about the below expression

System.Text.RegularExpressions.Regex.IsMatch(CurrentRow(0).ToString, "@.*.com")



Ref code
Example.zip (11.4 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.