IF condition read and assign only email ID

Hello all,

I have values in an excel in the picture uploaded:

image

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

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

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

regards
ahmad

@Yugal_Raju
Try this :

CurrentRow.Item(0).ToString.Contains("@gmail.com")

Yes it works. Thank you

we are happy to help

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