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? …

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

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

balupad14 (Balamurugan) December 21, 2019, 12:40pm 4

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

Topic		Replies	Views
Get column values Help excel , activities , string , question , data_manipulation	7	1576	December 17, 2019
Rows which contain commas Help datatable , excel , activities , string , question , condition	2	1026	December 18, 2019
How can I determine if a Excel column contains a specific value? Activities excel , read-column	4	2040	July 24, 2021
How to check if an excel file contains a keyword in a particular row(not specified cell) Help excel , activities , question	22	4738	November 16, 2019
How to check if a cell contains a list of cells? Studio excel , activities , question	6	1557	March 23, 2020