IF condition read and assign only email ID

[Yugal_Raju]

Hello all,

I have values in an excel in the picture uploaded:

I want to create a condition in which when the row is read only the cells containing the mails are considered and then assign them to variable.

Please Help

[ashwin.ashok ((TheCodingTheory))]

Hi @Yugal_Raju .

Could you try passing this into an If Activity?

CurrentRow(0).ToString.Contains("@")

If there is a specific format you are looking for, please let us know.
I can come up with a suitable Regex Pattern for you.

Kind Regards,
Ashwin A.K

[Ahmad_Rais (Ahmad)]

how about something like
if
row(column).tostring contains “@gmail.com” or contains “.com”
then
assign
var = row(column).tostring

regards
ahmad

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@Yugal_Raju
Try this :

CurrentRow.Item(0).ToString.Contains(“@gmail.com”)

[Yugal_Raju]

Yes it works. Thank you

[Ahmad_Rais (Ahmad)]

we are happy to help