UiPath Automation Developer Associate Training Series 2025 - Session 2

In session 2, we will introduce you to Data manipulation in UiPath Studio.

Topics covered:

Data Manipulation

What is Data Manipulation
Strings
Lists
Dictionaries
RegEx Builder
Date and Time

Required Self-Paced Learning for this session:

Data Manipulation with Strings in UiPath Studio (v2022.10) 2 modules - 1h 30m - https://academy.uipath.com/courses/data-manipulation-with-strings-in-studio
Data Manipulation with Lists and Dictionaries in UiPath Studio (v2022.10) 2 modules - 1h - https:/academy.uipath.com/courses/data-manipulation-with-lists-and-dictionaries-in-studio
Data Manipulation with Data Tables in UiPath Studio (v2022.10) 2 modules - 1h 30m - https:/academy.uipath.com/courses/data-manipulation-with-data-tables-in-studio


⁉️ For any questions you may have, please use the dedicated Forum thread. You can tag the hosts and mentors directly and they will reply as soon as possible.

1. The UiPath word mark, logos, and robots are registered trademarks owned by UiPath, Inc. and its affiliates. UiPath (R) is a registered trademark in the United States and several countries across the globe. See TMEP 906. ©2024 UiPath. All rights reserved. UiPath Automation Developer Associate Training Series - Session 2 Data Manipulation with Strings, Collections and Data T ables

2. Introduction to Data manipulation Data manipulation with Strings Data manipulation with Lists and Dictionaries Data manipulation with Data tables Wrap Up Agenda

3. Data Manipulation

4. Process of modifying, structuring, formatting, or sorting data to make it easier to read, use and manage. Key Advantages: Ensures data is structured and stored consistently. Integrates data from various sources and provides consolidated view. Organizes and summarizes data. Transform data to make it compatible for data analysis. Data Manipulation - Introduction Structured / Semi-structured Un-structured Data

5. Operations for Data Manipulation Common operations for data manipulation are: Retrieving Specify conditions to extract, filter or summarize data Adding Add new data in a data structure Deleting Remove entries from a data structure Modifying Changes the existing entries in a data structure

6. String Manipulation

7. String Manipulations String.Concat(Var1, Var2, ...) VarName.Contains(“text”) VarName.IndexOf(“a”) VarName.LastIndexOf(“a”) VarName.Replace(“original”, “replaced”) VarName1.Substring(startIndex, length) String.Format(“{0} is {1}”, VarName1, VarName2) VarName.Split(“|“c)(index) String.Join(“|”, CollVarName1)

8. More String Manipulation… Regular Expression is a specific search pattern that can be used to easily match, locate and manage text. Creation of RegEx expressions are quite challenging. Used for Input Validation, Data Parsing / Manipulation RegEx Builder simplifies the creation of regular expressions.

9. String Manipulation Demo

10. Data Manipulation with Lists and Dictionaries

11. Collections Data structure that holds multiple items of same or different types. Deal with dynamic data that needs to be stored and manipulated in automation workflows.

12. Data Manipulation in Lists Build Collection – Creates a collection of items of the same type as the first specified element Append Item to Collection – Appends one or more items at the end of the specific collection. Exists in Collection – Indicates whether a given item is present in the collection or not by giving Boolean output. Merge Collection – Combines the elements of two collections in a new collection or an existing one. Filter Collection – Filters collection based on specified conditions Remove from collection – Removes a specific item from a collection Converts specific collection to a Data Table

13. Data Manipulation in Dictionary Adding and deleting (key, value) pairs. - VariableName.Add(Key, Value) – Adds item to a dictionary variable - VariableName.Remove(Key) – Removes item from a dictionary variable Retrieving values from Dictionary - VariableName.Item(Key) - Returns the dictionary item of the given key - VariableName.Count – Returns the total number of key, value pairs in the dictionary - VariableName.ContainsKey(Key) – Checks if a given key is present – Boolean Value Re-assigning new values to existing keys.

14. Data Manipulation with Lists and Dictionaries Demo

15. Working with DataTables

16. DataTable is the type of variable that can store data as a simple spreadsheet with rows and columns. You can identify each piece of data based on its unique column and row coordinates. Some common actions with Data tables are: Loop through the data Filter Data Add/Modify Data Sort Data Table

17. Data Tables Demo

18. Fun Time!! Quiz Time!!

19. Week 1 – Self Study Assignments - Data Manipulation with Strings in Studio (v2022.10) 2 modules - 1h 30m https://academy.uipath.com/courses/data-manipulation-with-strings-in-studio - Data Manipulation with Lists and Dictionaries in Studio (v2022.10) 2 modules - 1h https:/academy.uipath.com/courses/data-manipulation-with-lists-and-dictionaries-in-studio - Data Manipulation with Data Tables in Studio (v2022.10) 2 modules - 1h 30m https:/academy.uipath.com/courses/data-manipulation-with-data-tables-in-studio What’s next?

20. Exercise – Data tables

21. Thank You !!! Any questions?