How to check if a certain string exists in a data table?


Hello everyone,

I have a data table and I would like to check for all the rows if the word “Hello” is contained in such rows.

When I use the activity for each row and then if -> datatable.tostring.contains(“Hello”) it does not work.

What could I do?

Thanks !


Hi @pal1910

You are almost there. Use Output Data Table activity to output your entire Data Table to a string. Then use your mentioned .Contains method with that string to do the check.


Thank you very much.

However, I would like to know the number of the row that contains the string.

If I convert the data table into a string, I will not be able to know the number of the row. Am I right?



Use this


And Please Update


It doesnt work.





See attachment for the working solution :slight_smile: (7.6 KB)

I hope it is clear, but let me know if you have any questions.