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

vishnu_prasad21 · December 18, 2019, 5:03am

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

vishal.kp · December 18, 2019, 5:05am

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

system · December 21, 2019, 5:05am

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

balupad14 · December 21, 2019, 12:40pm

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