How to check if a specific row in an excel table contains a specific alphabet or character?

Help
, ,
1

Hi expert’s,

Need some coding help here… I need to check if a specific row in my excel contains a specific alphabet or character?

For example.
Column1 - Column2 - Column N
VB2345Sd - A99 - Nth column
VC2345Ad- B88

I need to check if all rows in column 1 contains character V or not?

How to code this in if activity?

Thank you in advance :slight_smile:

1 Like
2

you can use for each row and put an if inside it then => row(“columnname”).tostring.contains(“alphabet”)

1 Like
3

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

4

Hi @vishnu_prasad21,

you can use the find activity to search the value in excel . It has a feature that you can specify the range.

Regards
Balamurugan.S