Hi, Can someone please tell me how I can search for a particular string in a cell, and find its corresponding column name The sample table would look like below: [image] I need to look for ‘-Yes’ in the cell, and then give me its corresponding column name Thanks in Advance!

How to check for every cell if it contains a particular string in a datatable

Matt_S (Matt S) September 4, 2020, 1:08pm 3

In excel? You can just use a filter on Col2
Datatable in UiPath you should be able to use function to filter the dt where column contains the string. Her is one that may work:

How to check for every cell if it contains a particular string in a datatable