How to check if a string exists in datatable using UiPath

Question

How can I check if a particular string exists in a datatable using UiPath?

Answer 1

Hi @Ravi, to check whether a string is present in a data table or not, you need to use ReadRange activity to read your excel file and store its output in a data table.Then use ForEachRow activity to read each row of the data table and use If activity to put the condition for matching the string. 
Use .Contains function to check whether the string is present or not. If the string is present, display the row of data table where its present using Message Box activity:

Comments

I have data table with first name,last name,phone number, now i need to check each phone number and add condition on phone number that it is  valid or not then need to perform activities based on that. Can we use array with .contains? as of now I have coded like below but I need to check for many phone numbers

row("MOB NOS").ToString .contains("123456982")

---

You could probably try using Array.contains for this scenario.