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 18 in RPA by Ravi
204 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 18 by Anvi
• 5,880 points

Related Questions In RPA

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,090 points
744 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,090 points
88 views
0 votes
2 answers

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

1. First use the excel application scope ...READ MORE

answered 6 days ago in RPA by Venkat
• 260 points
1,125 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 Jun 29, 2018 in RPA by wrecker
• 3,090 points
253 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 13 in RPA by Abha
• 5,840 points
61 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 in RPA by Anvi
• 5,880 points
234 views
0 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 in RPA by Pratibha
• 2,520 points
326 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 in RPA by Pratibha
• 2,520 points
177 views
0 votes
1 answer

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

Hey @Priya, for checking if an UI ...READ MORE

answered Mar 20 in RPA by Anvi
• 5,880 points
240 views
0 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 in RPA by Anvi
• 5,880 points
437 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.