UiPath RPA Academy "Lesson 3 - Data Manipulation" 之學習心得 PART3

Lesson 3 - Data Manipulation
第三章以及一些上課筆記，最近吃了一頓飯，😕😕😕重新思考系所的問題...!

Data的可能格式:

• Text
• Numbers
• DateTimes
• Arrays
• Lists
• Tables

Scalar variables: Hold a single value of a fixed type. (Ex. Characters, Booleans, Numbers, Date Times)
Collections: (Ex. Arrays, Lists, Queues)
註：

• Strings: 因為文串屬於一種文字的集合，所以Strings也屬於Collections
• Dictionary: two synchronize collections of associated names and values(可以reference by name)
• Tables: Structure that hold data indexed by rows and columns
• Generic Value優點：flexible use of variables, without type considerations
  缺點：lack of specific handling methods, imprecise expression evaluations

Array與List類似，但仍有不同之處：

• Array為固定size
• List可以增加length(利用Invoke Method)

Escape sequence:不產生String delimiters

Split method: 用來extract text delimited by known markers(可能是space)

Handling data有兩種方式：

1. String concatenation 運用”+”，可以用來合併很多資料
   註：String Methods很多種
2. String.Format取代原先的value

If the dtNewHires datatable has 4 columns, in this order : [ID, Name, Age, Sex] and 2 rows: [1, Daniel, 38, M] ; [2, Andra, 24, F], what is the result of the expression dtNewHires.Rows(0)(1)?

Daniel
1
Andra
2

Which of the following data types are included in the Collections category?

Int32
List
Array
Dictionary

Which of the following statements is true regarding Lists and Arrays?

You can iterate through a List using a For Each loop activity.
You can add any number of elements to an array.
List items can be added using an Add to Collection activity.
Array and List elements can be accessed by index.

If currentRow represents a row from a DataTable with two column in this order: Name and Age, what expression can be used to obtain the value from the column Age?

currentRow.Age
currentRow("Age")
currentRow(2)
currentRow(1)

What activities can be used to iterate through an Array?

Flow Decision
For Each
While
For Each Row(X)

What variable type can you use to efficiently store the current time inside your workflows?

DateTime
Integer
Array<String>
String

How can we test if a given address (a string variable called fullAddress) can be found on a particular street (a string variable called streetName)?

fullAddress.Has(streetName)
streetName.Has(fullAddresss)
fullAddress.Contains(streetName)
streetName.Contains(fullAddress)

How can you identify a column in a data table?

Using the column name
Using the row index
Using the row name
Using the column index

What .Net method of the datatable object can be used to filter a table by a condition?

Select(推測)
Clone
Filter
ToString(X)

The String.Format(“Input = {0} and Output = {1}”, “1”,”2”) expression returns the following text:

Input = 1 and Output = 2
Input = 0 and Output = 0
Input = {0} and Output = {1}(X)
Input = 1 and Output = 1

SHARE AND LIKE IF IT HELPS