How to check if a string exists in datatable using UiPath

0 votes
How can I check if a particular string exists in a datatable using UiPath?
Mar 19, 2019 in RPA by Ravi
17,748 views

1 answer to this question.

0 votes

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:

answered Mar 19, 2019 by Anvi
• 14,150 points
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.

Related Questions In RPA

0 votes
1 answer
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,110 points
3,435 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

Just use a wildcard in selector. Given ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
1,133 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
14,734 views
0 votes
1 answer

What is Get Jobs activity used for in UiPath Studio?

Hey @Rakesh, Get Jobs Activity can be ...READ MORE

answered Mar 14, 2019 in RPA by Abha
• 28,140 points
3,010 views
0 votes
1 answer

How to format text in notepad using UiPath?

Hey @Rashmi, if you want to automate ...READ MORE

answered Mar 18, 2019 in RPA by Anvi
• 14,150 points
8,140 views
+2 votes
1 answer

How can I display current date in "dd-MMM-yy" format in UiPath Studio?

Hi Shilpa, if you want to display ...READ MORE

answered Mar 18, 2019 in RPA by Pratibha
• 3,690 points
17,133 views
0 votes
1 answer

What is Flow Decision used for in UiPath studio?

Hi Smita, Flow Decision activity is a ...READ MORE

answered Mar 19, 2019 in RPA by Pratibha
• 3,690 points
6,293 views
0 votes
2 answers

How can I check if an element or window exists using UiPath Studio?

Element Exists help you READ MORE

answered Jun 24, 2019 in RPA by anonymous
25,978 views
+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,150 points
22,387 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP