Support Portal

for ProcessRobot and WinAutomation

Variables

Logical AND/OR operator in IF conditions
The AND "&&" operator can be used inside an "If" condition using the following format First Operand: %TextVar_1 == "AB...
Mon, 10 Sep, 2018 at 5:51 PM
Assign a List item / DataTable cell to a variable
Everything contained between two percentage marks "%" is evaluated, and replaced with the variable's value. List Let's say %MyList%...
Thu, 24 Jan, 2019 at 3:13 PM
Handling of List Variables
Using lists of variables one can process data in bulk. Under "Variables Actions", one may find List-specific actions such as Create New List, ...
Fri, 8 Mar, 2019 at 5:53 PM
How to merge/join lists and data tables
Merging of list variables is supported through the "Merge Lists" Action. However, data tables cannot be merger directly. You could following worka...
Wed, 5 Dec, 2018 at 11:51 PM
How to format a number
Use the "Convert Number to Text" Action to change the format of a numerical value.  Choose the number of decimal places that will be included be...
Mon, 10 Dec, 2018 at 8:57 AM
How to delete a row/column from a data table
There is not a direct way to delete a row/column from a table. However, it is feasible with the following workaround:  Using the "Excel" Actions...
Fri, 4 Jan, 2019 at 10:11 AM
Sort a list of dates
Assume that you have a list of dates and want to sort it by the most recent one. What you have to do is loop through the items of the list and use the "...
Fri, 4 Jan, 2019 at 10:30 AM
How to check if a variable is numeric or not at run-time
You would need to add the following logic in your script, in order to check whether a specific variable is a number or not. Let's suppose that %NewVar...
Fri, 25 Jan, 2019 at 9:41 PM
Retrieving custom fields of Credential Manager
The ProcessRobot Credential Manager allows us to save custom credentials, with a variable number of custom fields. However, when retrieving the cre...
Mon, 18 Feb, 2019 at 6:38 PM
Check if a variable is "NULL"
In order to check if a variable is "NULL" we need to perform the following actions: First we need to use the action "Convert Json To Cust...
Fri, 8 Mar, 2019 at 6:08 PM