Data Types Cheat Sheet

COOL STUFF

String.IsNullOrEmpty(strMyVar) => test for if not initialized

strMyVar + ” and another string” => concatenation

Split(strMyVar, ” “) => returns array – second arg is delim

strMyVar.Replace(vbcr, ” “).Replace(vblf, ” “) => strips carriage returns

strMyVar.IndexOf(“searchFor“) => returns integer position where 1st found

strMyVar.IndexOf(“searchFor“, startpos, countOfLettersToSearch) => to limit search

strMyVar.Substring(startPos, length) => return an embedded string

Left(strMyVar, numChars) => return left (or right) side of string

Trim(strMyVar) => trims whitespace both sides – also RTrim and LTrim

INITIALIZE

arrMyVar = New Integer(){} => will need to init with elements later
arrMyVar = New Integer(10){} => with 11 places
arrMyVar = New Integer(){1,2,3} => init with elements

ASSIGN

arrMyVar = {1, 2, 3} => entire array
arrMyVar(2) = 5 => specific element (must be inbounds)

COOL STUFF

arrMyVar.Length => how many places

arrMyVar(0) => get specific element (0-based)

USEFUL ACTIVITIES

For Each => iteration

declare

INITIALIZE

(be sure to initialize at Variables panel) New List(Of whatever)

lstMyVar = New List(Of Integer) => count is now 0

lstMyVar = New List(Of Integer) From {1,2,3,4,5} => init and assign

useful activities

• Create List
• Append Item To List
• Update List
• Read List Item
• For Each

COOL STUFF

lstMyVar.Count => how many elements

lstMyVar.Item(0) => get specific element (0-based)

Enumerable.Concat(1stList, 2ndList).ToList => join two lists together

String.Join(“,”, lstMyVar) => all elements into string for printing

declare

INITIALIZE

dicMyVar = New Dictionary(Of Integer, String) => count is now 0 (can be used to clear)

dicMyVar = New Dictionary(Of Integer, String) From {{1, “val1”}, {2, “val2”}} => init and assign

assign

dicMyVar(keyname) = whatever => will overwrite if key already there else will add

useful activities

• For Each => key in dicMyVar.Keys (arg type same as key type) then to get value dicMyVar(key)

COOL STUFF

dicMyVar.Count => how many elements

dicMyVar(keyname) => get value by key

dicMyVar.Keys => array of keynames

boolKeyExists = dicMyVar.ContainsKey(keyname)

boolValExists = dicMyVar.ContainsValue(value)

boolWasRemoved = dicMyVar.Remove(keyname)

dict = dict.Concat(New Dictionary(Of String,Int32)From{{“Teacher”,3},{“Doctor”,3}}).ToDictionary(Function(kv) kv.Key,Function(kv) kv.Value)
=> Concat a second dictionary to first

dict2 = dict1.ToDictionary(Function(kv) kv.Key,Function(kv) kv.Value.Copy) => deep copy one dict into another

declare

INITIALIZE

dtMyVar = New DataTable()

dtMyVar.Columns.Add(“ColumnName”, GetType(System.String)) => assign to Object data type

useful activities

• Read Range Workbook => save to data table variable Properties > Data Table
• Build Data Table => wizard to build columns/values put variable name in Properties > Output
• Add Data Column
• Add Data Row
• Clear Data Table
• Sort Data Table
• Filter Data Table
• For Each Row in Data Table => loop
• Output Data Table as Text => outputs to string so can log
• Write Data Table To Excel

COOL STUFF

dtMyVar.Rows.Count-1 => last row

dtMyVar.Rows(rownum).Item(“ColumnName”) => value in column/row

CurrentRow.Item(“ColumnName”) => value in loop

dtMyVar.Rows.Add(“ColumnName”, 32 ) => add row and data all at once

dtTable.Rows(0)(“ColumnName”).GetType().ToString() => check the data type of a column

‘Loop through data and change data type (Using invoke code)
dtTable.AsEnumerable().ToList().ForEach (
Sub(rs)
rs(“Date”)=CDate(rs(“Date”))
End Sub
)

I highly recommend a package called BalaReva.EasyDataTable.Activities. It makes changing data types of a column much easier. Learn how to use it here.