Data Manipulation in UiPath

Data Manipulation in UiPath

Data Manipulation includes dealing withvarious variables and performing operations with them. UiPath Studio offers a wide range of variables to support automation: –

  • Text variables: – This type of variable can store only string data type and is enclosed in double quotes. You can define the type as “System.String” to declare this kind of variable.
system string
  • True or False variables: – This type of variable stores only two possible values – true or false and supports Boolean data type. You can define the types as “System.Boolean” to declare this kind of variable. Make use of this data type when working with flow decisions in Studio.
True or false variables

Number variables: – This type of variable stores numeric data and supports Integer values. You can define the type as “Int32” to declare this kind of variable. Use the “.ToString” method to convert the integer variable to a string and display as such.

Number variables
Array variables

To access all the values you store in an array, give a reference of index in the output. For example, to retrieve the first name from the arrStrnames variable, write line as arrStrNames(0)

Arrstrnames

List variables: – This type of variable will allow you to store a varying number of multiple values of the same data type. For example, you can declare a list of strings as – System.Collections.Generic.List<System.String>

List variables
  • Dictionary variables: – A dictionary is an array which can hold a varying number of elements associated with a key-value format. The value is retrieved from the defined key in the variable. To declare a dictionary variable, use “System.Collections. Generic.Dictionary<System.String,System.String>” as the data type.
Dictionary variables
  • Date and Time variables: – This type of variable stores information about any date and time. Declaration is done by using “System.DateTime” as the data type. The default format used is “day.hh:mm:ss”. You can modify the format to only retrieve a particular component.
  • Data table variables: – This variable can store information in a database or a simple spreadsheet consisting of rows and columns. Declare this kind of variable by using “System.Data.DataTable”. You can make use of this variable when dealing with excel/workbook automation.
  • Generic-Value variables: – This variable can store any kind of data such as numbers, text, dates, arrays, etc. Use this data type when unsure of the exact structure of data you are dealing with. Declare using “UiPath.Core.GenericValue” data type.

String Manipulation in UiPath

UiPath offers a wide range of functions that can be used to perform operations on strings. Details to each are as below:

  • Split: This function will divide the string into two parts based on the split identifier mentioned. For an example, take a string “str” as “My:name:is” and define the slit function as – “Split(str,”:”). This will split the string in three different sections based on “:” and to retrieve any one section, you can refer to the output by an index as done in an array.
split
  • Substring: This function lets you customize your division of the entire string.
Sub string
  • Trim: This function removes the leading spaces (Ltrim), trailing spaces(RTrim) or leading and trailing spaces (Trim) from a string. Use this function as – Trim(yourstring), LTrim(yourstring), RTrim(yourstring).
  • Replace: This function allows you to replace a character with another character specified. Here “:” gets replaced with “_”
replace

Remove: This function removes the text specified. It can be understood as an inverse operation to substring.

Remove

• Left: This function outputs the text from the left side of the variable value.

left
  • Right: This function outputs the text from the right side of the variable value.
Right
  • Regex.Replace: This function will replace an expression combination according to the regex specified with a character. Here, “\d” is used as a regular expression to find digit combinations only and then they are replaced by an underscore “_”.
Regex Replace

Leave a Reply

Retype the CAPTCHA code from the image
Change the CAPTCHA codeSpeak the CAPTCHA code
 

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,
 

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
 
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.
 

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.
 

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.
 

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
 
India
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
US
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info