Contact Us

Popular posts from this blog

UiPath - Convert String to DateTime

Image
UiPath - Convert String to DateTime We need to convert a string date to DateTime format very frequently whenever we are going to work with date and times. Let’s understand and convert string to DateTime in UiPath using an example below: Step 1 – Take a variable/argument to store the string date in_DateString = "01/01/2020" Assign String Date Step 2 – Take a variable/argument to store the string date format in_DateStringFormat = "dd/MM/yyyy" Assign String Date Format Step 3 – Convert string to datetime using below provided method out_DateTime = DateTime.ParseExact(in_DateString,in_DateStringFormat, System.Globalization.CultureInfo.InvariantCulture) Convert String To DateTime The variable/argument out_DateTime would contain the date value in DateTime format.
Read more

UiPath - Initialize Array and Assign value to Array

Image
UiPath - Initialize Array and Assign Value to Array During developing automation solutions, we need to perform a lot of data manipulation and using arrays is very frequent. We need to learn about initialize empty array in UiPath and initialize array with values in UiPath. Let’s understand with example 😃 Initialize empty string array in UiPath dataArray = New String(){} Assign - Empty String Array to dataArray Initialize array with values in UiPath dataArray = New String(){"value1", "value2", "value3"} Assign - String Array with values to dataArray
Read more

Filter DataTable in UiPath Studio

Image
UiPath - Filter DataTable It is very important to be able to perform filter operations on DataTable in order to get a desired result. Let’s take an example of having a table with columns such as FirstName, LastName and Age. We need to filter the records having FirstName as "David". Input DataTable variable – InputDT Output Filtered DataTable variable – FilteredDT Method 1 – Using "Filter Data Table" Activity Add the variables and conditions as shown below: Filter DataTable Activity We can also choose the columns needed as a resulted FilteredDT, by adding columns via the Output Columns Tab as shown below: Filter DataTable Activity - Keep/Remove Output Columns Method 2 – Using "DataTable.Select() method" Using this method, we can directly assign filtered rows to a DataRow array or DataTable using below given expression. By default, this method returns the array of data rows, but we can convert it to DataTable.
Read more