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

Help
,
1

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!

2

@PavithraSundaram
find some starter help here
GetAllRowColIdx_By1Value.xaml (9.5 KB)

input:
grafik
output:
grafik

it is looking for a searchterm and is returning, rowindex, columnindex and columnname for each found match

Feel free to adopt it to your scenario

2 Likes
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:

4

Thank u so much! I shall try this…