Overview
Overview
You can convert and control specific variables or values using the features provided by the DataConverter library.
The features provided by the DataConverter library are as follows:
One-dimensional array: Clone, IndexOf, Reverse, Sort, StringToArray, StringToNumArray, ToArray2D, ToString
Two-dimensional array: Clone, GetColumnValues, GetLabeledColumnValues, GetLabeledRowValues, GetRowValues, RotateCCW, RotateCW, SortByColumn, SortByRow
Text string conversion: ToString, Format, Trim, ReplaceAll, Split, ExtractByRegex, IsMatch
Numeric conversion: Abs, Ceil, Floor, Max, Min, Round, ToNumber
Date conversion: AddDays, AddHours, AddMinutes, AddMonths, AddSeconds, AddYears, DateFormat, FromExcelDate, ToDateTime, ToUTCDateTime
Json conversion: GetValueByKey, ToJsonObject, ToString
Xml conversion: ToString, GetValueByXpath
Point conversion: Offset, ToPoint
Rect conversion: Center, Offset, ToRect
Type | method | Description |
|---|---|---|
Array_1D | Clone | Returns a copy of the one-dimensional array entered in the data field. |
IndexOf | Returns the first matching index in the one-dimensional array entered in the data field. | |
Reverse | Sorts the elements in the one-dimensional array entered in the data field in reverse order. | |
Sort | Sorts the elements of the one-dimensional array entered in the data field. | |
StringToArray | Converts the text string entered in the data field into a one-dimensional array. | |
StringToNumArray | Converts the text string entered in the data field into a numeric, one-dimensional array. | |
ToArray2D | Converts the one-dimensional array entered in the data field into a two-dimensional array. | |
ToString | Converts the one-dimensional array entered in the data field into text strings. | |
Array_2D | Clone | Returns a copy of the two-dimensional array entered in the data field. |
GetColumnValues | Returns the column value for a specific index in the two-dimensional array entered in the data field. | |
GetLabeledColumnValues | Returns the values of a column with a specific name in the two-dimensional array entered in the data field. | |
GetLabeledRowValues | Returns the values of a row with a specific name in the two-dimensional array entered in the data field. | |
GetRowValues | Returns the row value for a specific index in the two-dimensional array entered in the data field. | |
RotateCCW | Rotates a two-dimensional array entered in the data field 90 degrees counterclockwise. | |
RotateCW | Rotates a two-dimensional array entered in the data field 90 degrees clockwise. | |
String | ToString | Converts the data entered in the data field into string type. |
Format | Returns the result of applying the arg value to the FormatString entered in the data field. | |
Trim | Converts the data entered in the data field into string type and deletes the spaces in the front and back. | |
ReplaceAll | Searches for a specific text string from the strings entered in the data field and replaces all the instances with another string. | |
Split | Splits the input text string entered in the data field with a specific character and stores the split strings in an array. | |
ExtractByRegex | Extracts the value in the text entered in the data field that matches the regular expression specified in the pattern field and returns them. | |
IsMatch | Verifies if the text entered in the data field matches the regular expression specified in the pattern field and returns the result as "True" or "False.” | |
Number | ToNumber | Converts the data entered in the data field into Number type. |
Max | Compares the data entered in the data1 field with the number entered in the data2 field and returns the greater value. | |
Min | Compares the data entered in the data1 field with the number entered in the data2 field and returns the smaller value. | |
Round | Returns the data entered in the data field after rounding it at the decimal point. For example, when a number is an input in the Args field, the value will be rounded at the corresponding place. | |
Ceil | Returns the data entered in the data field after rounding it down at the decimal point. | |
Floor | Returns the data entered in the data field after rounding it up at the decimal point. | |
Abs | Returns the absolute value of the value entered in the data field. | |
DateTime | ToDateTime | Converts the dateformat string entered in the data field into DateTime. If dateformat is entered in the format field, the string is returned in the relevant format. |
ToUTCDateTime | Converts the date format string entered in the data field into UTCDateTime. If the date format is entered in the format field, the string is returned in the suitable format. | |
FromExcelDate | Converts the Date string imported from the Excel file specified in the data field into UTCDateTime. If the dateformat is entered in the format field, the string is returned in the suitable format. | |
AddYears, AddMonths, AddDays, AddHours, AddMinutes, AddSeconds | You can add or subtract the time or date entered in the format field from the datetime entered in the data field. | |
DateFormat | Converts a string into a text string according to the dateformat entered in the data field. | |
Json | ToString | Returns the Json object entered in the data field as a text string. |
ToJsonObject | Returns the Json type text string entered in the data field as a Json object. | |
GetValueByKey | Returns the value entered in the key field from the Json type string entered in the data field. | |
Xml | ToString | Returns the XmlElement entered in the data field as a string. |
GetValueByXpath | Returns the xpath value entered in the xPath field from the XML type string entered in the data field. | |
Point | Offset | Adds the offset value to the specified Point object entered in the data field and returns it. |
ToPoint | Converts the Point-type text string entered in the data field into a Point object. | |
Rect | Center | Converts the center coordinates of the Rect object entered in the data field into a Point object. |
Offset | Adds the offset value to the Rect object entered in the data field and returns it. | |
ToRect | Converts the Rect-type text string entered in the data field into a Rect object and returns it. |
Use Designer or File Explorer to refer to the samples for the DataConverter library.
• On Designer: Menu > Help > Sample > Sample > DataConverter
• On File Explorer: C:\Users\user\AppData\Roaming\Brity RPA Designer\samples\DataConverter
Common Properties
Common Properties
DataConverter
Configure settings related to the data converter.
Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|
[Output] Result | Variable | N | - | Y | Returns the data conversion result. |
ARGURMENTS
You can enter the input parameters required for data conversion. Input parameters may vary depending on the activities.
MORE OPTIONS
Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|
On Error | Combination box | N | - | N | Specify an action to carry out when an error occurs at the time of execution. - If not specified: Output errors and exit the task. - --Ignore--: Ignore the error. - --Retry--: Try the activity one more time. - --Goto--: Try the scenario for the specified time if the activity fails. - _Event: Select an event created within the project. If a handler is specified: Call the specified handler. |
DESCRIPTION
Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|
DESCRIPTION | Text | N | - | N | Enter the description for the activity card. The description entered in the DESCRIPTION field is used as the description of the activity. A representative value will be displayed in the absence of the DESCRIPTION input. |
Array1D_Clone
Array1D_Clone
Overview
This activity card copies one-dimensional arrays. In addition, this activity card is used to store one-dimensional arrays in variables.
Application procedures
In the [Output] Result field, enter the variable to store the copied one-dimensional array.
In the data field, enter the one-dimensional array to copy.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Returns the copied one-dimensional array. | [0, 1, 2, 3] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Variable | Y | - | N | Enter the one-dimensional array to copy. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Copy the one-dimensional array stored in the variable and output the result in a message box.
Array1D_Clone Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the copied array
array1 = Variable that store the target one-dimensional array to copy (Default: [10,20,30,40,50,60,70,80,90,100])
Used properties
[Output] Result =
RESULTdata =
this.array1
Remarks
In the data field, a one-dimensional array must be entered.
Related/Similar activities
Array1D_IndexOf
Array1D_IndexOf
Overview
This activity card searches for a specific value in a one-dimensional array and returns the first matching value index. For example, if "'456" is searched in the array of [1,23,456,7890,123,456], the index for the third value, "'2," will be returned as a result.
Application procedures
In the [Output] Result field, enter the variable to store the index value searched in the array.
In the data field, enter a one-dimensional array.
In the value field, enter the value to search for.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Int | - | Returns the index value of value found in the array . | data : [10,20,30] value : 20 > Result : 1 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Variable | Y | - | N | Enter the data for the one-dimensional array. |
N | [ARGUMENTS] value | Variable | Y | - | N | Enter the object (value) to search for in the array. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | Common property of the DataConverter library. |
Example of utilization
In the one-dimensional array of ['aa','bb','cc','dd','ee','ff','gg','hh','ii','jj'], verify the order of 'dd', and output the index value in a message box.
Array1D_IndexOf Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the index value searched in the array
Used properties
[Output] Result =
RESULTdata = ['aa','bb','cc','dd','ee','ff','gg','hh','ii','jj']
value = 'dd'
Remarks
In the data field, a one-dimensional array must be entered.
Array1D_Reverse
Array1D_Reverse
Overview
This activity card sorts the values in a one-dimensional array in reverse order. For example, it converts an array of [1,3,8,4] into an array of [4,8,3,1].
Application procedures
In the [Output] Result field, enter the variable to store the reversed array.
In the data field, enter the one-dimensional array to reverse.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Returns an array sorted in reverse order of the values in the specified array. | data : [10,20,30]> Result : [30,20,10] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional array | Y | - | N | Enter the one-dimensional array to reverse. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Sort the one-dimensional array, [1,2,3,4,5,6,7,8,9,0], in reverse order and output the result in a message box.
Array1D_Reverse Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the reversed one-dimensional array
Used properties
[Output] Result =
RESULTdata = [1,2,3,4,5,6,7,8,9,0]
Remarks
In the data field, a one-dimensional array must be entered.
Array1D_Sort
Array1D_Sort
Overview
This activity card sorts the values in a one-dimensional array in ascending order. For example, it converts an array of [1,3,8,5,2,9] into an array of [1,2,3,5,8,9].
Application procedures
In the [Output] Result field, enter the variable to store the sorted array.
In the data field, enter the one-dimensional array to sort.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Returns an array sorted in ascending order of the values in the specified array. | data : [1,3,8,5,2,9]> Result : [1,2,3,5,8,9] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Variable | Y | - | N | Enter the one-dimensional array to sort. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Sort the one-dimensional array, [2,8,4,5,3,7,1,9,0,6], in ascending order and output the result in a message box.
Array1D_Sort Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the sorted one-dimensional array
Used properties
[Output] Result =
RESULTdata = [2,8,4,5,3,7,1,9,0,6]
Remarks
In the data field, a one-dimensional array must be entered.
Related/Similar activities
Array2D_SortByRow, Array2D_SortByColumn
Array1D_StringToArray
Array1D_StringToArray
Overview
This activity card converts the specified text string into a one-dimensional array. For example, text string “1,2,a,b” can be converted into an array of ['1','2','a','b'] by using commas (“,”) as the separator.
Application procedures
In the [Output] Result field, enter the variable to store the converted one-dimensional array.
In the data field, enter the text string with separators to convert it into a one-dimensional array.
In the separator field, enter the separator to divide the values in the text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | String | Converts the specified string to a one-dimensional array. | data : '1,2,a,b' separator : ',' > Result : ['1','2','a','b'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the text string with separators to be converted into a one-dimensional array. |
N | [ARGUMENTS] seperator | String | Y | - | N | Enter the separator to divide the values in the text string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert a text string, “a1, a1, a2, a3, a4, a5, a6, a7, a8, a9, a0” into a one-dimensional array by using the commas (“,”) as the separator and output the result in a message box.
Array1D_StringToArray Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the converted one-dimensional array
Used properties
[Output] Result =
RESULTdata = 'a1,a2,a3,a4,a5,a6,a7,a8,a9,a0'
seperator = ','
Related/Similar activities
Array1D_StringToNumArray, Array1D_ToNumArray
Array1D_StringToNumArray
Array1D_StringToNumArray
Overview
This activity card converts a text string of specified numbers into a one-dimensional numeric array.
For example, the text string “1,2,3,4” can be converted into an array of [1,2,3,4] by using commas (",") as the separators.Application procedures
In the [Output] Result field, enter the variable to store the converted one-dimensional array.
In the data field, enter the text string with separators to convert it into a one-dimensional array.
In the separator field, enter the separator to divide the values in the text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | Int | Converts the specified string to a numeric one-dimensional array. | data : '1,2,3,4' separator : ',' > Result : [1,2,3,4] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the text string with separators to be converted into a one-dimensional array. |
N | [ARGUMENTS] seperator | String | Y | - | N | Enter the separator to divide the values in the text string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert a text string, “1,2,3,4,5,6,7,8,9,0” into a one-dimensional array by using commas (“,”) as the separator and output the result in a message box.
Array1D_StringToNumArray Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the one-dimensional array
Used properties
[Output] Result =
RESULTdata = '1,2,3,4,5,6,7,8,9,0'
seperator = ','
Related/Similar activities
Array1D_ToNumArrayArray1D_StringToArray
Array1D_ToArray2D
Array1D_ToArray2D
Overview
This activity card converts a specified one-dimensional array into a two-dimensional array with a single row. For example, it converts a one-dimensional array [1,2,3] into a two-dimensional array [[1,2,3]].
Application procedures
In the [Output] Result field, enter the variable to store the converted two-dimensional array.
In the data field, enter the one-dimensional array to convert into a two-dimensional array.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data . | Converts the specified one-dimensional array to a two-dimensional array of one type. | data : [1,2,3] > Result : [[1,2,3]] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional array | Y | - | N | Specify the one-dimensional array to convert into a two-dimensional array. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the one-dimensional array, [10,20,30,40,50,60,70,80,90,100] stored in the “array1” variable into a two-dimensional array and output the result in a message box.
Array1D_ToArray2D Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable to store the two-dimensional array
array1 = Variable that stores the one-dimensional array that is the target of the conversion (Default: [10,20,30,40,50,60,70,80,90,100])
Used properties
[Output] Result =
RESULTdata =
this.array1
Remarks
In the data field, a one-dimensional array must be entered.
Array1D_ToNumArray
Array1D_ToNumArray
Overview
This activity card converts a specified one-dimensional array into a numeric one-dimensional array. For example, it converts array ['123','456', '789'] into [123, 456, 789].
Application procedures
In the [Output] Result field, enter the variable to store the converted numeric one-dimensional array.
In the data field, enter the number-type one-dimensional text array to convert into a one-dimensional numeric array.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Converts the specified one-dimensional array to a numeric one-dimensional array. | data : ['1','2','3'] > Result : [1,2,3] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional array | Y | - | N | Enter the number-type one-dimensional text array. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the number-type text array, ['10', '20', '30'], into a numeric one-dimensional array and output the result in a message box.
Array1D_ToNumArray Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT = Variable that stores the number-type one-dimensional array
array1 = Variable that stores the text array to convert into a numeric one-dimensional array (Default: ['10','20','30'])
Used properties
[Output] Result =
RESULTdata = ['10', '20', '30']
Remarks
In the data field, a one-dimensional array must be entered.
Related/Similar activities
Array1D_StringToNumArray, Array1D_StringToArray
Array1D_ToString
Array1D_ToString
Overview
This activity card converts a specified one-dimensional array into a text string. For example, it converts an array of [1,2,3,4,5] into a text string “1/2/3/4/5” by using separators (“/”).
Application procedures
In the [Output] Result field, enter the variable to store the converted text string.
In the data field, enter the one-dimensional array to convert into a text string.
In the separator field, enter the separator to divide the values in the text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Converts the specified one-dimensional array to a string. | data : [1,2,3] separator : '/' > Result : '1/2/3' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional array | Y | - | N | Enter the one-dimensional array to convert into a text string. |
N | [ARGUMENTS] seperator | String | Y | - | N | Enter the separator to divide the values in the array. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the one-dimensional array, [1,2,3,4,5,6,7,8,9,0], into a text string by using commas (“,”) as separators and output the result in a message box.
Array1D_ToString Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array1D
Used variables
RESULT: Variable to store the converted text string
this.array1: Variable that stores the one-dimensional array that is the target of the conversion (Default: [1,2,3,4,5,6,7,8,9,0])
Used properties
[Output] Result =
RESULTdata = [1,2,3,4,5,6,7,8,9,0]
Remarks
In the data field, a one-dimensional array must be entered.
Related/Similar activities
Array1D_Filter
Array1D_Filter
Overview
This activity card returns the filtered value of the specified one-dimensional array.
Application procedures
[Output] Result에 필터링된 결괏값을 저장할 변수를 지정합니다.
data에 1차원 배열을 입력하세요.
operator에서 연산자를 선택합니다.
value에 비교할 값을 입력합니다.
Card output properties
property | Return Type | Additional Explanation of Return | explanation | Example results |
|---|---|---|---|---|
Common Properties - DataConverter Card Properties | Array1D | - | Returns a filtered, one-dimensional array. | data : [1,2,3]operator : Greater Thanvalue : 2> Result : '[3]' |
Card input properties
Common | property | type | Required | unit | Auto-fill | explanation |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional arrays | And | - | N | Enter the one-dimensional array that you want to filter. |
N | [ARGUMENTS] operator | Combo Box | And | - | N | Select a filter operator. |
N | [ARGUMENTS] value | variable | And | - | N | Enter the values you want to compare. |
And | Card AttributesCOMMON ATTRIBUTES - MORE OPTION CARD ATTRIBUTES | - | - | - | - | This is a common property of the DataConverter library. |
And | Card AttributesCOMMON ATTRIBUTES - DESCRIPTION CARD PROPERTIES | - | - | - | - | This is a common property of the DataConverter library. |
Example of utilization
Outputs a value greater than 1 from a one-dimensional array ([1,2,3,4,5,6,7,8,9,0]) to the message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_Array1D
Used variables
RESULT: Variable to store the converted string
this.array1 : A variable that stores the one-dimensional array to be converted(initial value : [1,1,2,3,4,5,6,7,8,9])
Used properties
[Output] Result = RESULT
data = [1,2,3,4,5,6,7,8,9,0]
operator = Greater Than
value = 5
Remarks
The data attribute must be a one-dimensional array.
Related/Similar activities
Array1D_Remove
Array1D_Remove
Array1D_Remove
Overview
Returns the result of the deleted values that correspond to the criteria in the specified one-dimensional array.
Application procedures
In Output, specify a variable to store the deleted array.
Enter a one-dimensional array for data.
For operator, select an operator.
For value, enter the value you want to compare.
Card output properties
property | Return Type | Additional Explanation of Return | explanation | Example results |
|---|---|---|---|---|
Common Properties - DataConverter Card Properties | Array1D | - | Returns a deleted one-dimensional array. | data : [1,2,3]operator : Greater Thanvalue : 2> Result : '[1,2]' |
Card input properties
Common | property | type | Required | unit | Auto-fill | explanation |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | One-dimensional arrays | And | - | N | Enter the one-dimensional array that you want to filter. |
N | [ARGUMENTS] operator | Combo Box | And | - | N | Select a filter operator. |
N | [ARGUMENTS] value | variable | And | - | N | Enter the values you want to compare. |
And | Card AttributesCOMMON ATTRIBUTES - MORE OPTION CARD ATTRIBUTES | - | - | - | - | This is a common property of the DataConverter library. |
And | Card AttributesCOMMON ATTRIBUTES - DESCRIPTION CARD PROPERTIES | - | - | - | - | This is a common property of the DataConverter library. |
Example of utilization
Outputs a result of a one-dimensional array ([1,1,2,3,4,5,6,7,8,9]) with values greater than 0 deleted to the message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_Array1D
Used variables
RESULT: Variable to store the converted string
this.array1 : A variable that stores the one-dimensional array to be converted(initial value : [1,1,2,3,4,5,6,7,8,9])
Used properties
[Output] Result = RESULT
data = [1,2,3,4,5,6,7,8,9,0]
operator = Greater Than
value = 5
Remarks
The data attribute must be a one-dimensional array.
Related/Similar activities
Array1D_Filter
Array2D_Clone
Array2D_Clone
Overview
This activity card copies specified two-dimensional arrays.
Application procedures
In the [Output] Result field, enter the variable to store the copied two-dimensional array.
In the data field, enter the two-dimensional array to copy.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data . | Returns an array of copies of the specified two-dimensional array. | 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to copy. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Copy the two-dimensional array stored in the variable and output the result in a message box.
Array2D_Clone Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the copied array
array2DValue: Variable that stores the two-dimensional array to copy (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValue
Related/Similar activities
Array2D_GetColumnValues
Array2D_GetColumnValues
Overview
This activity card fetches a value in a specific column of a two-dimensional array.
Application procedures
In the [Output] Result field, enter the variable to store the value searched in the specific column of a two-dimensional array.
In the data field, enter the two-dimensional array.
In the columnIndex field, enter the index of the column where the value to search for is located.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Returns the value in a specific column (columnIndex) within the specified two-dimensional array . | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 columnIndex : 2 > Result : ['c','3','6'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to search the column. |
N | [ARGUMENTS] columnIndex | Number | Y | - | N | Enter the column index. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Fetch the value in the column that matches the specified index of the two-dimensional array stored in the “array2DValue” variable and output it in a message box.
Array2D_GetColumnValues Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the value in the specified column
array2DValue = Variable that stores the two-dimensional array (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValuecolumnIndex = 2
Related/Similar activities
Array2D_GetLabeledColumnValues
Array2D_GetLabeledColumnValues
Overview
This activity card searches the first row of a two-dimensional array for a column with a specific value and fetches all of the values in the matching column.
Application procedures
In the [Output] Result field, enter the variable to store the values in the searched column.
In the data field, enter the two-dimensional array.
In the labelName field, enter the value of the specific column to search for in the first row.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data . | Returns the value in the value (labelName) of a specific column within the specified two-dimensional array . | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 labelName : 'c' > Result : ['c','3','6'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to search the column. |
N | [ARGUMENTS] labelName | String | Y | - | N | Enter the value to search for in the first row. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Search the first row of a two-dimensional array for a column that includes “BB” and output all the values in that column in a message box.
Array2D_GetLabeledColumnValues Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the value in the specified column
array2DValue = Variable that stores the two-dimensional array (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValuelabelName = 'BB'
Related/Similar activities
Array2D_GetLabeledRowValues
Array2D_GetLabeledRowValues
Overview
This activity card searches the first column of a two-dimensional array for a row with a specific value and fetches all of the values in the matching row.
Application procedures
In the [Output] Result field, enter the variable to store the values in the searched row.
In the data field, enter the two-dimensional array.
In the labelName field, enter the value of the specific column to search for in the first column.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
One-dimensional array | The elements of the array are determined by data. | Returns the value in the value (labelName) of a specific row within the specified two-dimensional array . | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 labelName : 'a' > Result : ['a','b','c'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to search the row. |
N | [ARGUMENTS] labelName | String | Y | - | N | Enter the value to search for in the first column. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Search the first column of a two-dimensional array for a row that includes “a” and output all of the values in that row in a message box.
Array2D_GetLabeledRowValues Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the value in the specified column
array2DValue = Variable that stores the two-dimensional array (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValuelabelName = 'a'
Related/Similar activities
Array2D_GetLabeledColumnValues
Array2D_GetRowValues
Array2D_GetRowValues
Overview
This activity card fetches a value in a specific row of an array.
Application procedures
In the [Output] Result field, enter the variable to store the value searched in the specific row of a two-dimensional array.
In the data field, enter the two-dimensional array.
In the rowindex field, enter the index of the row where the value to search for is located.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Result | One-dimensional array | The elements of the array are determined by data . | Returns the value at a specific row (rowIndex) within the specified two-dimensional array . | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 labelName : 'a' > Result : ['a','b','c'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to search the row. |
N | [ARGUMENTS] rowIndex | Number | Y | - | N | Enter the row index. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Fetch the value in the row of the third index (4th column) of the two-dimensional array stored in the “array2DValue” variable and output it in a message box.
Array2D_GetRowValues Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the value in the specified row
array2DValue = Variable that stores the two-dimensional array (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValuerowIndex = 3
Related/Similar activities
Array2D_RotateCCW
Array2D_RotateCCW
Overview
This activity card rotates a two-dimensional array 90 degrees counterclockwise. After the conversion, the first row becomes the first column, and the last column becomes the first row.
Application procedures
In the [Output] Result field, enter the variable to store the result of the rotation.
In the data field, enter the two-dimensional array to rotate 90 degrees counterclockwise.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data. | Returns the value of the specified two-dimensional array rotated counterclockwise by 90 degrees.※ The first row becomes the first column, and the last column becomes the first row. | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 > Result : 0: c | 3 | 6 1: b | 2 | 5 2: a | 1 | 4 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the array to rotate 90 degrees counterclockwise. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Rotate a two-dimensional array stored in the “array2DValue” variable 90 degrees counterclockwise and output the result in a message box.
Array2D_RotateCCW Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT: Variable to store the rotated two-dimensional array.
array2DValue: Variable that stores the two-dimensional value (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValue
Related/Similar activities
Array2D_RotateCW
Array2D_RotateCW
Overview
This activity card rotates a two-dimensional array 90 degrees clockwise. After the conversion, the first column becomes the first row, and the last row becomes the first column.
Application procedures
In the [Output] Result field, enter the variable to store the result of the rotation.
In the data field, enter the two-dimensional array to rotate 90 degrees clockwise.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data. | Returns the value of the specified two-dimensional array rotated 90 degrees clockwise.※ The first column becomes the first row, and the last row becomes the first column. | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 > Result : 0: c | 3 | 6 1: b | 2 | 5 2: a | 1 | 4 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-dimensional array. | Y | - | N | Enter the array to rotate 90 degrees clockwise. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Rotate a two-dimensional array stored in the “array2DValue” variable 90 degrees clockwise and output the result in a message box.
Array2D_RotateCW Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Array2D
Used variables
RESULT = Variable to store the rotated two-dimensional array.
array2DValue = Variable that stores the two-dimensional array (Default: [['AA','BB','CC','DD','EE'],['a','1','2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']] )
Used properties
[Output] Result =
RESULTdata =
this.array2DValue
Related/Similar activities
Array2D_SortByColumn
Array2D_SortByColumn
Overview
This activity card sorts the row values of a two-dimensional array according to the column value that matches the specified index.
Application procedures
In the [Output] Result field, enter the variable to store the sorting result.
In the data field, enter the two-dimensional array to sort according to the column value.
In the index field, enter the index of the column where the values to sort are located.
Set the descending property to select the sort order.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data. | Returns an array sorted by the value in a specific column( index ) of the specified array. | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 index: 2 descending: off > Result : 0: c | 3 | 6 1: b | 2 | 5 2: a | 1 | 4 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | Data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to sort. |
N | Index | Number | Y | - | N | Enter the column index as the basis of the sorting. |
N | Descending | bool | Y | - | Y | Select the sort order (ascending or descending). - On: Sort in descending order. - Off: Sort in ascending order. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Array2D_SortByRow
Array2D_SortByRow
Overview
This activity card sorts the column values of a two-dimensional array according to the row value that matches the specified index.
Application procedures
In the [Output] Result field, enter the variable to store the result of the sorting.
In the data field, enter the two-dimensional array to sort according to the row value.
In the index field, enter the index of the row where the values to sort are located.
Set the descending property to select the sort order.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | The elements of the array are determined by data. | Returns an array sorted by the value in a specific row ( index ) of the specified array. | data : 0: a | b | c 1: 1 | 2 | 3 2: 4 | 5 | 6 index: 0 descending: off > Result : 0: c | 3 | 6 1: b | 2 | 5 2: a | 1 | 4 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | Data | Two-dimensional array. | Y | - | N | Enter the two-dimensional array to sort. |
N | Index | Number | Y | - | N | Enter the row index as the basis of the sorting. |
N | Descending | bool | Y | - | Y | Select the sort order (ascending or descending). - On: Sort in descending order. - Off: Sort in ascending order. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Array2D_RowFilter
Array2D_RowFilter
Overview
Returns a two-dimensional array filtered by the value of the column that corresponds to the specified specific index.
Application procedures
In Output, specify a variable to store the deleted array.
Enter a two-dimensional array in data.
For indexCol, enter the column index that you want to apply the filter to.
For operator, select an operator.
For value, enter the value you want to compare.
Card output properties
property | Return Type | Additional Explanation of Return | explanation | Example results |
|---|---|---|---|---|
Common Properties - DataConverter Card Properties | Array2D | - | Returns a filtered two-dimensional array. | data : [[1,2,3],[4,5,6]]indexCol : 1operator : Greater Thanvalue : 2> Result : '[[4,5,6]]' |
Card input properties
Common | property | type | Required | unit | Auto-fill | explanation |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-Dimensional Array | Y | - | N | Enter the two-dimensional array that you want to filter. |
N | [ARGUMENTS] indexCol | number | Y | - | N | Enter the column index to which you want to apply the filter. |
N | [ARGUMENTS] operator | Combo Box | Y | - | N | Select a filter operator. |
N | [ARGUMENTS] value | variable | Y | - | N | Enter the values you want to compare. |
Y | Card AttributesCOMMON ATTRIBUTES - MORE OPTION CARD ATTRIBUTES | - | - | - | - | This is a common property of the DataConverter library. |
Y | Card AttributesCOMMON ATTRIBUTES - DESCRIPTION CARD PROPERTIES | - | - | - | - | This is a common property of the DataConverter library. |
Example of utilization
In a two-dimensional array ([[2,1,2],[3,4,5],[6,7,8]]), the array with a column index of 9 outputs a value greater than 1 to the message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_Array2D
Used variables
RESULT: Variable to store the converted string
this.array1 : A variable that stores the 2D array to be converted(initial value: [[1,2,3],[4,5,6],[7,8,9]]
Used properties
[Output] Result = RESULT
data = [[1,2,3],[4,5,6],[7,8,9]]
indexCol = 1
operator = Greater Than
value = 5
Remarks
The data attribute must be a two-dimensional array.
Related/Similar activities
Array2D_ColumnFilter
Array2D_ColumnFilter
Array2D_ColumnFilter
Overview
Returns a two-dimensional array filtered by row values that correspond to a specific specified index.
Application procedures
In Output, specify a variable to store the deleted array.
Enter a two-dimensional array in data.
For indexRow, enter the column index that you want to apply the filter to.
For operator, select an operator.
For value, enter the value you want to compare.
Card output properties
property | Return Type | Additional Explanation of Return | explanation | Example results |
|---|---|---|---|---|
Common Properties - DataConverter Card Properties | Array2D | - | Returns a filtered two-dimensional array. | data : [[1,2,3],[4,5,6]]indexRow : 1operator : Greater Thanvalue : 5> Result : '[[3],[6]]' |
Card input properties
Common | property | type | Required | unit | Auto-fill | explanation |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Two-Dimensional Array | Y | - | N | Enter the two-dimensional array that you want to filter. |
N | [ARGUMENTS] indexRow | number | Y | - | N | Enter the row index to which you want to apply the filter. |
N | [ARGUMENTS] operator | Combo Box | Y | - | N | Select a filter operator. |
N | [ARGUMENTS] value | variable | Y | - | N | Enter the values you want to compare. |
Y | Card AttributesCOMMON ATTRIBUTES - MORE OPTION CARD ATTRIBUTES | - | - | - | - | This is a common property of the DataConverter library. |
Y | Card AttributesCOMMON ATTRIBUTES - DESCRIPTION CARD PROPERTIES | - | - | - | - | This is a common property of the DataConverter library. |
Example of utilization
In a two-dimensional array ([[2,1,2],[3,4,5],[6,7,8]]), the array with a row index of 9 outputs a value greater than 1 to the message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_Array2D
Used variables
RESULT: Variable to store the converted string
this.array1 : A variable that stores the 2D array to be converted(initial value: [[1,2,3],[4,5,6],[7,8,9]])
Used properties
[Output] Result = RESULT
data = [[1,2,3],[4,5,6],[7,8,9]]
indexRow = 1
operator = Greater Than
value = 5
Remarks
The data attribute must be a two-dimensional array.
Related/Similar activities
Array2D_RowFilter
DateTime_AddDays
DateTime_AddDays
Overview
This activity card adds the specified number of days to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the dayValue field, enter the number of days to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime obtained by adding the specified number of days ( dayValue ) to the specified date . | data: '2021-01-01 09:00:00' dayValue: 1 > Result : '2021-01-02 09:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] dayValue | Number | Y | - | N | Enter the number of days to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add one day to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddDays Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1dayValue = 1
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddHoursDateTime_AddMinutesDateTime_AddMonthsDateTime_AddSecondsDateTime_AddYears
DateTime_AddHours
DateTime_AddHours
Overview
This activity card adds the specified number of hours to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the hourValue field, enter the number of hours to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime obtained by adding the specified date to the specified time (hourValue). | data: '2021-01-01 09:00:00' hourValue: 2 >Result : '2021-01-01 11:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] hourValue | Number | Y | - | N | Enter the number of hours to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add two hours to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddHours Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1hourValue = 2
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddDaysDateTime_AddMinutesDateTime_AddMonthsDateTime_AddSecondsDateTime_AddYears
DateTime_AddMinutes
DateTime_AddMinutes
Overview
This activity card adds the specified number of minutes to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the minuteValue field, enter the number of minutes to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime that is the specified date plus the specified minute (minuteValue). | data: '2021-01-01 09:00:00' hourValue: 30 >Result : '2021-01-01 09:30:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] minuteValue | Number | Y | - | N | Enter the number of minutes to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add 30 minutes to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddMinutes Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1minuteValue = 30
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddDaysDateTime_AddHoursDateTime_AddMonthsDateTime_AddSecondsDateTime_AddYears
DateTime_AddMonths
DateTime_AddMonths
Overview
This activity card adds the specified number of months to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the monthValue field, enter the number of months to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime obtained by adding the specified date to the specified month (monthValue). | data: '2021-01-01 09:00:00' monthValue: 3 > Result : '2021-04-01 09:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] monthValue | Number | Y | - | N | Enter the number of months to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add three months to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddMonths Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1monthValue = 3
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddDaysDateTime_AddHoursDateTime_AddMinutesDateTime_AddSecondsDateTime_AddYears
DateTime_AddSeconds
DateTime_AddSeconds
Overview
This activity card adds the specified number of seconds to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the secondValue field, enter the number of seconds to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime that is the specified date plus the specified second (SecondValue). | data: '2021-01-01 09:00:00' secondValue: 30 > Result : '2021-01-02 09:00:30' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] secondValue | Number | Y | - | N | Enter the number of seconds to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add 30 seconds to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddSeconds Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1secondValue = 30
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddDaysDateTime_AddHoursDateTime_AddMinutesDateTime_AddMonthsDateTime_AddYears
DateTime_AddYears
DateTime_AddYears
Overview
This activity card adds the specified number of years to a DateTime string.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the yearValue field, enter the number of years to add.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
DateTime | - | Returns a DateTime obtained by adding the specified number of years (yearValue) to the specified date . | data: '2021-01-01 09:00:00' yearValue: 2 > Result : '2023-01-02 09:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] yearValue | Number | Y | - | N | Enter the number of years to add. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add two years to the DateTime string (2020-05-26 02:00:00) stored in the “date1” variable and output the result in a message box.
DateTime_AddYears Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1yearValue = 2
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_AddDaysDateTime_AddHoursDateTime_AddMinutesDateTime_AddMonthsDateTime_AddSeconds
DateTime_DateFormat
DateTime_DateFormat
Overview
This activity card converts a DateTime string into a text string in the specified date format. For example, “2020-05-26 02:00:00” can be converted to the “yyyy/MM/dd” format. (Note: yyyy - 4 digit year, MM - month, dd - date)
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the format field, enter the date format to be used.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns a DateTime with a specified date format (format) applied to the specified date . | data: '2021-01-01 09:00:00' format: 'MM-dd-yyyy' > Result : '01-01-2021' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] format | String | Y | - | N | Enter the DateTime format that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the DateTime string stored in the “date1” variable (2020-05-26 02:00:00) into the “05-26-2020” format and output the result in a message box.
DateTime_DateFormat Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1format = 'MM-dd-yyyy'
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_ToDateTimeDateTime_ToUTCDateTime
DateTime_FromExcelDate
DateTime_FromExcelDate
Overview
This activity card converts a value in ExcelDate format into DateTime format.
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the ExcelDate value to change.
In the format field, enter the date format to be used.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns a DateTime with a specified date format ( format ) applied to the specified date .. | data: 42456.77 format: 'yyyy-MM-dd HH:mm:ss' > Result : '2016-03-27 18:28:48' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | Number | Y | - | N | Enter the ExcelDate or OLE automation date value. |
N | [ARGUMENTS] format | String | Y | - | N | Enter the DateTime format that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert an ExcelDate value, “42456.77” into a DateTime string, “2016-03-27” and output the result in a message box.
DateTime_FromExcelDate Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT: Variable to store the changed DateTime string.
Used properties
[Output] Result =
RESULTdate = 42456.77
format = 'yyyy-MM-dd'
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_ToDateTimeDateTime_DateFormatDateTime_ToUTCDateTime
DateTime_ToDateTime
DateTime_ToDateTime
Overview
DateTime_ToDateTime converts a DateTime string into a DateTime string with the specified date and time formats. (Note: yyyy - 4-digit year, MM - month, dd - date, hh - hour, mm - minute, ss - second)
Application procedures
In the [Output] Result field, enter the variable to store the changed DateTime string.
In the date field, enter the DateTime string to change.
In the format field, enter the date format to be used.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns a DateTime with a specified date format (format) applied to the specified date . | data: '2021-01-01 09:00:00' format: 'MM-dd-yyyy hh:mm' > Result : '01-01-2021 09:00'' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] format | String | Y | - | N | Enter the DateTime format that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the DateTime string, “2020-05-26 02:00:00” into the “05-26-2020 02:00:00” format and output the result in a message box.
DateTime_ToDateTime Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdate =
this.date1format = 'MM-dd-yyyy HH:mm'
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_DateFormatDateTime_ToUTCDateTime
DateTime_GetNthWeekOfMonth
DateTime_GetNthWeekOfMonth
Overview
Returns the date and time corresponding to the specified day of the week in the specified ordinal week, relative to the corresponding month of the specified DateTime object. The time information is returned as the time of the specified DateTime object.
Application procedures
In the [Output] Result field, enter the variable to store the calculated DateTime string.
In the date field, enter the DateTime string to change.
In the nthWeek field, enter the number of weeks.
In the dayOfWeek field, enter the day of the week.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the date and time of the specified week and day of the week relative to the corresponding month of the object in the specified date. | date: '2022-04-01 10:00:00' nthWeek: 2dayOfWeek: 'mon' > Result : '2022-04-11 10:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Automatic setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | DateTime | Y | - | N | Enter the DateTime string to count. |
N | [ARGUMENTS] nthWeek | Number | Y | - | N | Enter the number of weeks. |
N | [ARGUMENTS] dayOfWeek | String | Y | - | N | Enter the day of the week that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the DateTime string, “2022-04-15 10:00:00” format and output the result in a message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the calculated DateTime string
Used properties
[Output] Result = RESULT
date = '2022-04-15 10:00:00'
nthWeel = 2
dayOfWeek = 'monday'
Remarks
The date property value must be a DateTime string.
Related/Similar activities
DateTime_GetNextDay, DateTime_GetLastDateOfMonth
DateTime_GetNextDay
DateTime_GetNextDay
Overview
Returns the date and time corresponding to the specified day of the week in the specified week after the date and time in the specified DateTime object. The time information is returned as the time of the specified DateTime object.
Application procedure
In the [Output] Result field, enter the variable to store the calculated DateTime string.
In the date field, enter the DateTime string to change.
In the nthWeek field, enter the number of weeks.
In the dayOfWeek field, enter the day of the week.
Card output properties
Property | Type | Additional comment | Description | Example |
|---|---|---|---|---|
String | - | Returns the date and time on the specified day of the week in the specified week after the corresponding date and time in the object on the specified date . | date: '2022-04-15 10:00:00' (Friday)nthWeek: 1dayOfWeek: 'Friday' > Result : '2022-04-22 10:00:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | DateTime | Y | - | N | Enter the DateTime string to count . |
N | [ARGUMENTS] nthWeek | Number | Y | - | N | Enter the number of weeks. |
N | [ARGUMENTS] dayOfWeek | String | Y | - | N | Enter the day of the week that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the DateTime string, “2022-04-15 10:00:00” the date of Monday after 2 weeks format and output the result in a message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the calculated DateTime string
Used properties
date = '2022-04-15 10:00:00'
nthWeel = 2
dayOfWeek = 'monday'
Remarks
The date property value must be a DateTime string.
Related/Similar activities
DateTime_GetNthWeekOfMonth, DateTime_GetLastDateOfMonth
DateTime_GetLastDateOfMonth
DateTime_GetLastDateOfMonth
Overview
Returns the date and time of the last date relative to the corresponding month of the specified DateTime object. The time information is returned as the time of the specified DateTime object.
Application procedures
In the [Output] Result field, enter the variable to store the calculated DateTime string.
In the date field, enter the DateTime string to change.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the date and time of the last date relative to the month in the object in the specified date . | date: '2022-04-15 10:00:00' > Result : '2022-04-30 10:00:00' |
Card input properties
Common | Properties | Type | Required | unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | DateTime | Y | - | N | Enter the DateTime string to count . |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
The last date of the month (April), the DateTime string '2022-04-15 10:00:00', is output to the message box.
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the calculated DateTime string
Used properties
[Output] Result = RESULT
date = '2022-04-15 10:00:00'
Remarks
The date property value must be a DateTime string.
Related/Similar activities
DateTime_GetNthWeekOfMonth, DateTime_GetNextDay
DateTime_ToUTCDateTime
DateTime_ToUTCDateTime
Overview
DateTime_ToUTCDateTime converts a DateTime string into a UTC DateTime.
UTC stands for Coordinated Universal Time, which has been the world standard time since January 1, 1927. UTC is a standard time based on the International Atomic Time and leap second correction that is universally used around the world.
Application procedures
In the [Output] Result field, enter the variable to store the DateTime string converted into UTC.
In the date field, enter the DateTime string to change.
In the format field, enter the date format to be used.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns a DateTime with a specified date format ( format ) applied to the specified date . | data: '2021-01-01 09:00:00' format: 'MM-dd-yyyy hh:mm' > Result : '01-01-2021 09:00' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] date | JSON string | Y | - | N | Enter the DateTime string to change. |
N | [ARGUMENTS] format | String | Y | - | N | Enter the DateTime format that will be used. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the DateTime string, “2020-05-26 02:00:00” into the UTC format (05-25-2020 17:00) and output the result in a message box.
DateTime_ToUTCDateTime Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_DateTime
Used variables
RESULT = Variable to store the changed DateTime string
date1 = Variable that stores the DateTime string (Default: '2020-05-26 02:00:00')
Used properties
[Output] Result =
RESULTdata =
this.date1format = 'MM-dd-yyyy HH:mm'
Remarks
In the data field, a DateTime string must be entered.
Related/Similar activities
DateTime_ToDateTimeDateTime_DateFormat
Json_GetValueByKey
Json_GetValueByKey
Overview
This activity card returns a key value in a JSON object.
Application procedures
In the [Output] Result field, enter the variable to store the searched key value.
In the data field, enter a JSON string.
In the key field, enter the key value to search for.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Object | - | Returns the value corresponding to key in the specified data . | data: { 'name' : 'James', 'number': 10 } key: 'number' > Result : 10 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | JSON string | Y | - | N | Enter the JSON string. |
N | [ARGUMENTS] key | String | Y | - | N | Enter the key value to search for. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Search the JSON string stored in the “json_data” variable for the “number” key value(‘10’) and output the result in a message box.
Json_GetValueByKey Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Json
Used variables
RESULT: Variable to store the searched key value
json_data: Variable that stores the JSON string (Default: '{ \"name\": \"James\", \"number\": 10 }')
Used properties
[Output] Result =
RESULTdata =
this.json_datakey = 'number'
Remarks
In the data field, a JSON string must be entered.
Related/Similar activities
Json_ToJsonObject, Json_ToString
Json_ToJsonObject
Json_ToJsonObject
Overview
This activity card converts a specified text string into a JSON object.
Application procedures
In the [Output] Result field, enter the variable to store the converted JSON object.
In the data field, enter a JSON string to convert into a JSON object.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
JSON object | - | Returns the value of converting the specified data into a JSON object. | { 'name' : 'James', 'number': 10 } |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | JSON string | Y | - | N | Enter the JSON string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the specified JSON string ({ \"name\": \"James\", \"number\": 10 }) into a JSON object and output the result in a message box.Json_ToJsonObject Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Json
Used variables
json_object = Variable to store the converted JSON object
Used properties
[Output] Result =
this.json_objectdata = '{ \"name\": \"James\", \"number\": 10 }'
Remarks
In the data field, a JSON string must be entered.
Related/Similar activities
Json_GetValueByKey, Json_ToString
Json_ToString
Json_ToString
Overview
This activity card converts the specified JSON object into a text string.
Application procedures
In the [Output] Result field, enter the variable to store the converted text string.
In the data field, enter a JSON string to convert into a text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the value of converting the specified data into a string. | ' {'name' : 'James', 'number': 10}' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | JSON string | Y | - | N | Enter the JSON object. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the specified JSON object into a text string. Convert the specified JSON object into a text string and output the result in a message box.
Json_ToString Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Json
Used variables
RESULT = Variable to store the converted text string
json_object = Variable to store the JSON object to convert into a text string
Used properties
[Output] Result =
RESULTdata =
this.json_object
Remarks
In the data field, a JSON object must be entered.
Related/Similar activities
Json_ToJsonObject, Json_GetValueByKey
Number_Abs
Number_Abs
Overview
This activity card returns the absolute value of a specified number.
Application procedures
In the [Output] Result field, enter the variable to store the absolute number that is the result of the conversion.
In the data field, enter the number to convert into an absolute number.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the absolute value of the specified data. | data: -1000 >Result: 1000 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Number | Y | - | N | Enter the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the specified number, “-1,000” into an absolute number and output the result in a message box.
Number_Abs Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata = -1000
Remarks
In the data field, a number must be entered.
Related/Similar activities
Number_Ceil
Number_Ceil
Overview
This activity card returns a minimum integer value that is larger than or equal to the specified number.
Application procedures
In the [Output] Result field, enter the variable to store the integer that is the result of the conversion.
In the data field, enter a number to convert to a minimum integer that is larger than or equal to the specified number.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the smallest integer value greater than or equal to the specified data | data: 1937.12 >Result: 1938 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Number | Y | - | N | Enter the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Find the minimum integer value that is larger than or equal to the specified number, “1982332.324” and output the result in a message box.
Number_Ceil Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata = 1982332.324
Remarks
In the data field, a number must be entered.
Related/Similar activities
Number_Floor
Number_Floor
Overview
This activity card returns a maximum integer value that is smaller than or equal to the specified number.
Application procedures
In the [Output] Result field, enter the variable to store the integer that is the result of the conversion.
In the data field, enter a number to convert to a maximum integer that is smaller than or equal to the specified number.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the smallest integer value less than or equal to the specified data. | data: 1937.12 >Result: 1937 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Number | Y | - | N | Enter the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Find the maximum integer value that is smaller than or equal to the specified number, “234324.109” and output the result in a message box.
Number_Floor Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata = 234324.109
Remarks
In the data field, a number must be entered.
Related/Similar activities
Number_Max
Number_Max
Overview
This activity card returns the larger of the two specified numbers.
Application procedures
In the [Output] Result field, enter the variable to store the result of the comparison.
In the data1 and data2 fields, enter the numbers to compare.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the greater of the specified data1 or data2. | data1: 4 data2: 2 >Result: 4 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data1 | Number | Y | - | N | Enter the number. |
N | [ARGUMENTS] data2 | Number | Y | - | N | Enter the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Find the larger number after comparing the two specified numbers, “4” and “2,” and output the result in a message box.
Number_Max Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata1 = 4
data2 = 2
Remarks
In the data1 and data2 fields, numbers must be entered.
Related/Similar activities
Number_Min
Number_Min
Overview
This activity card returns the smaller of the two specified numbers.
Application procedures
In the [Output] Result field, enter the variable to store the result of the comparison.
In the data1 and data2 fields, enter the numbers to compare.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the smaller of the specified data1 or data2. | data1: 4 data2: 2 >Result: 2 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data1 | Number | Y | - | N | Enter the number. |
N | [ARGUMENTS] data2 | Number | Y | - | N | Enter the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Find the smaller number after comparing the two specified numbers, “4” and “2,” and output the result in a message box.
Number_Min Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata1 = 4
data2 = 2
Remarks
In the data1 and data2 fields, numbers must be entered.
Related/Similar activities
Number_Round
Number_Round
Overview
This activity card returns the specified number after rounding it to the closest integer or to the specified decimal place.
Application procedures
In the [Output] Result field, enter the variable to store the resulting number rounded to the specified decimal place.
In the data field, enter the number to convert.
In the decimals field, enter the decimal place to round the number.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Double | - | Returns the value of the specified data rounded to the specified number of decimal places (decimals). | data: 1937.12 decimals: 1 >Result: 1938.1 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | Number | Y | Real Number | N | Enter the number. |
N | [ARGUMENTS] decimals | Number | Y | natural number | N | Enter the decimal place to round the number. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Round the specified number, “982734.999” to the third decimal place and output the result in a message box.
Number_Round Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata = 982734.999
decimals = 3
Remarks
In the data and decimals fields, number must be entered.
Number_ToNumber
Number_ToNumber
Overview
This activity card converts a numeric string into a Number object.
Application procedures
In the [Output] Result field, enter the variable to store the converted Number object.
In the date field, enter the numeric string to convert.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Object | int or long or double | Returns the value of converting the specified data into a numeric object. | data: '1937.12' >Result: 1938.12 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter a numeric string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Converts a numeric string "08923409" into a Number object and output the result in a message box.
Number_ToNumber Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Number
Used variables
None
Used properties
[Output] Result =
RESULTdata = '08923409'
Remarks
In the data field, a numeric string must be entered.
Point_Offset
Point_Offset
Overview
This activity card adds offset values to a specified Point object and returns it.
Application procedures
In the [Output] Result field, enter the variable to store the sum of the coordinates string and the offset values.
In the data field, enter the point-type string to add offset values.
In the offsetX and offsetY fields, enter the offset values for the X and Y coordinates.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Point | A Point object obtained by adding the offset value to the specified data is returned. | data: '10, 50' offsetX: 20 offsetY: 20 >Result: '30, 70' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the point-type string. |
N | [ARGUMENTS] offsetX | Number | Y | - | N | Enter the X-axis offset value. |
N | [ARGUMENTS] offsetY | Number | Y | - | N | Enter the Y-axis offset value. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add the offset values (X: 20, Y: 20) to the point-type string specified in the “pointValue” variable and output the result in a message box.
Point_Offset Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Point
Used variables
pointValue = Variable to store the coordinates of the Point object. (Default: '10, 50')
Used properties
[Output] Result =
RESULTdata =
this.pointValueoffsetX = 20
offsetY = 20
Remarks
In the data field, a coordinates string must be entered.
Related/Similar activities
Point_ToPoint
Point_ToPoint
Overview
This activity card converts a specified point-type string to a Point object.
Application procedures
In the [Output] Result field, enter the variable to store the results of converting a point string into a Point object.
In the data field, enter the point-type string to convert to a Point object.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Point | - | Converts the specified data into a Point object and returns it. | data: '10, 50' >Result: '10, 50' Result.X: 10 Result.Y: 50 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the point-type string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the point-type string (“10, 50”) specified in the “pointValue” variable into a Point object and output the result in a message box.
Point_ToPoint Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Point
Used variables
pointValue = Variable to store the coordinates of the Point object. (Default: '10, 50')
Used properties
[Output] Result =
RESULTdata =
this.pointValue
Remarks
In the data field, a coordinates string must be entered.
Related/Similar activities
Rect_Center
Rect_Center
Overview
This activity card converts the center coordinates of the specified Rect object into a Point object.
Application procedures
In the [Output] Result field, enter the variable to store the result of converting the center coordinates of a Rect object into a Point object.
In the data field, enter the rectangular boundary of the Rect object to convert to a Point object.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Point | - | Returns the center coordinates of the specified data as a Point object. | data: '20.30.10.10' >Result: '25,35 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the rectangular boundary of the Rect object (x, y, width, and hight). |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the center coordinate of the rectangular boundary specified in the “rectValue” variable ("20,30,10,10") into a Point object and output the result in a message box.Rect_Center Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Rect
Used variables
rectValue = Variable that stores the rectangular boundary of the Rect object (Default: ''20,30,10,10')
Used properties
[Output] Result =
RESULTdata =
this.rectValue
Remarks
In the data field, a coordinates string for a rectangular boundary must be entered.
Related/Similar activities
Rect_Offset
Rect_Offset
Overview
This activity card adds offset values to a specified Rect object and returns it.
Application procedures
In the [Output] Result field, enter the variable to store the sum of the rectangular boundary and the offset values.
In the data field, enter the rectangular boundary of the Rect object to add offset values.
In the offsetX and offsetY fields, enter the offset values for the X and Y coordinates.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Rect | - | Adds the OffSet value of the specified data and returns it. | data: '20.30.10.10' offsetX: 50 offsetY: 50 >Result: '70,80,10,10' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the rectangular boundary of the Rect object (x, y, width, and hight). |
N | [ARGUMENTS] offsetX | Number | Y | - | N | Enter the X-axis offset value. |
N | [ARGUMENTS] offsetY | Number | Y | - | N | Enter the Y-axis offset value. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Add the offset values (X: 50, Y: 50) to the rectangular boundary specified in the “rectValue” variable ("20, 30, 10, 10") and output the result in a message box.Rect_Offset Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Rect
Used variables
rectValue = Variable that stores the rectangular boundary of the Rect object (Default: ''20,30,10,10')
Used properties
[Output] Result =
RESULTdata =
this.rectValueoffsetX = 50
offsetY = 50
Remarks
In the data field, a coordinates string for a rectangular boundary must be entered.
Related/Similar activities
Rect_ToRect
Rect_ToRect
Overview
This activity card converts a specified Rect-type string into a Rect object and returns it.
Application procedures
In the [Output] Result field, enter the variable to store the result of converting a Rect-type string into a Rect object.
In the data field, enter the Rect-type string to convert to a Rect object.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
Rect | - | Converts the specified data into a Rect object and returns it. | data: '20.30.40.10' >Result: '20,30,40,10' Result.X: 20 Result.Y: 30 Result.Width: 40 Result.Height: 10 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the rectangular boundary of the Rect object (x, y, width, and hight). |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the rectangular boundary specified in the “rectValue” variable ("20,30,10,10") into a Rect object and output the result in a message box.Rect_ToRect Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_Rect
Used variables
rectValue = Variable that stores the rectangular boundary of the Rect object (Default: ''20,30,10,10')
Used properties
[Output] Result =
RESULTdata =
this.rectValue
Remarks
In the data field, a coordinates string for a rectangular boundary must be entered.
Related/Similar activities
String_ExtractByRegex
String_ExtractByRegex
Overview
This activity card returns a value in the specified string that matches the regular expression.
Application procedures
In the [Output] Result field, enter the variable to store the value that matches the regular expression.
In the data field, enter a target string.
In the pattern field, enter the regular expression to search for.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
one-dimensional array | String | Returns a value that matches the regular expression in the specified data . | data: 'Hello, World' pattern: '^\\w+,' > Result: ['Hello,'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target string to search. |
N | [ARGUMENTS] pattern | String | Y | - | N | Enter the regular expression to search for. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Search the “Hello, World” string stored in the “strRegex” variable using the regular expression and return the result in a message box.
String_ExtractByRegex Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
strRegex = Variable that stores the text string (Default: 'Hello, World')
Used properties
[Output] Result =
RESULTpattern = '^\\w+,'
Remarks
In the pattern field, the regular expression must be entered in compliance with the input rules.
Related/Similar activities
String_Format
String_Format
Overview
This activity card converts an object value into a text string according to a specified format.
Application procedures
In the [Output] Result field, enter the variable to store the changed text string.
In the format field, enter the format string.
In the args field, enter the array of variables that will be input to the format string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the value of the object ( args ) according to the specified format string ( format ). | format: '{0}, {1}, {2}' args: ['a', 'b', 'c'] > Result: 'a, b, c' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] format | String | Y | - | N | Enter a text string for the format type. |
N | [ARGUMENTS] args | String | Y | - | N | Enter an array of variables that will be input to the format type. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Enter the “['aa','bb','cc']” string stored in the “args” variable in the format string and output the result in a message box.
String_Format Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
args = Variable that stores the factors that will be input to the format string (Default: An array of ['aa','bb','cc'])
Used properties
[Output] Result =
RESULTformat: ['aa','bb','cc']
Remarks
In the format field, values must be entered in compliance with the input rules (Ex.: {0], {1}...).
String_IsMatch
String_IsMatch
Overview
This activity card verifies if a specified text string contains the string that matches the search string or regular expression.
Application procedures
In the [Output] Result field, enter the variable to store the verification result.
In the data field, enter a target string to search.
In the pattern field, enter a search string or regular expression.
Card properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
Y | Variable | Y | - | Y | Enter the variable to store the verification result of whether the specified string exists. “True” is returned if the matching string exists. “False” is returned otherwise. | |
N | [ARGUMENTS] data | String | Y | - | N | Enter the target text to search for. |
N | [ARGUMENTS] pattern | String | Y | - | N | Enter the search string or regular expression to search for. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Search the “Hello, World” string stored in the “strRegex” variable using the search string or regular expression and return the result in a message box.
String_IsMatch Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
strRegex = Variable that stores the text string (Default: 'Hello, World')
Used properties
[Output] Result =
RESULTpattern = 'Hello, World'
Remarks
In the pattern field, the regular expression must be entered in compliance with the input rules.
Related/Similar activities
String_ObjectToString
String_ObjectToString
Overview
This activity card converts a specified object into a text string.
Application procedures
In the [Output] Result field, enter the variable to store the converted text string.
In the data field, enter a target string to convert into a text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the value of converting the specified data into a string. | data : new Date('2021-01-01') > Result: '2021-01-01' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the object to convert. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the object stored in the “objectDate” variable (new Date('2020-05-27 05:00:00')) into a text string and output the result in a message box.String_ObjectToString Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
objectDate = Variable that stores the date-type object (Default: new Date('2020-05-27 05:00:00'))
Used properties
[Output] Result =
RESULTdata =
this.objectDate
String_ReplaceAll
String_ReplaceAll
Overview
This activity card converts a specified text string into a specific text string.
Application procedures
In the [Output] Result field, enter the variable to store the converted text string.
In the data field, enter a target string to convert.
In the oldValue field, enter the text string to be replaced (string to be searched).
In the newValue filed, enter the text string to replace the entire text string that is searched (string to replace the target).
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns the value in the specified data by replacing oldValue with newValue | data: 'Hello, World' oldValue: 'Hello' newValue: 'Hi' > Result: 'Hi, World' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target text string. |
N | [ARGUMENTS] oldValue | String | Y | - | N | Enter the text string to be replaced (string to be searched). |
N | [ARGUMENTS] newValue | String | Y | - | N | Enter the text string to replace the searched string (string to replace the target). |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Replace “Hello” with “Hi” in the string stored in the “strRegex” variable (“Hello, World”) and output the result in a message box.
String_ReplaceAll Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
strRegex = Variable that stores the text string (Default: 'Hello, World')
Used properties
[Output] Result =
RESULToldValue = 'Hello'
newValue = 'Hi'
String_Split
String_Split
Overview
This activity card splits the specified text string into specific text strings or arrays, and returns the one-dimensional text string arrays generated as the result.
Application procedures
In the [Output] Result field, enter the variable to store the converted one-dimensional array of strings.
In the data field, enter a target string to convert.
In the separator field, enter the separator to divide the values in the text string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
one-dimensional array | string | Returns an array created by dividing the specified data by a seperator. | data: 'Hello, World' seperator: ',' > Result: ['Hello', 'World'] |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target string to convert. |
N | [ARGUMENTS] seperator | Text string or character array | Y | - | N | Enter the separator to divide the values in the text string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Convert the text string stored in the “strRegex” variable (“Hello, World”) into a one-dimensional array by using a comma (“,”) as the separator and output the result in a message box.
String_Split Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
strRegex = Variable that stores the text string (Default: 'Hello, World')
Used properties
[Output] Result =
RESULTseperator = ','
Related/Similar activities
String_SplitTable
String_SplitTable
Overview
This activity card splits the specified text string into specific text strings or arrays, and returns the two-dimensional text string arrays generated as the result.
Application procedures
In the [Output] Result field, enter the variable to store the converted two-dimensional array of strings.
In the data field, enter a target string to convert.
In the rowSeparator field, enter the separator to divide values by row.
In the colSeparator field, enter the separator to divide values by column.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
2D Array | String | Returns an array created by dividing the specified data based on rowSeperator and colSeperator | data: '1,2,3/4,5,6/7,8,9' rowSeperator: '/; colSeperator: ',' > Result: 0: 1 | 2 | 3 1: 4 | 5 | 6 2: 7 | 8 | 9 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target text string for the extraction. |
N | [ARGUMENTS] rowSeperator | Text string or character array | Y | - | N | Enter the separator to split the target text string by row. |
N | [ARGUMENTS] colSeperator | Text string or character array | Y | - | N | Enter the separator to split the target text string by column. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Split the text string stored in the “strTable” variable (“1,2,3/4,5,6/7,8,9”) and convert it into a two-dimensional array by using commas (“,”) as row separators and slashes (“/”) as column separators. Then, output the result in a message box.
String_SplitTable Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
strTable = Variable that stores the text string (Default: '1,2,3/4,5,6/7,8,9')
Used properties
[Output] Result =
RESULTrowSeperator ='/'
colSeperator = ','
Related/Similar activities
String_Trim
String_Trim
Overview
This activity card removes the spaces in the front and back of the specified text string.
Application procedures
In the [Output] Result field, enter the variable to store the specified text string after removing the spaces in the front and back.
In the data field, enter a target string.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Returns a value with all leading and trailing spaces removed from the specified data . | data: ' Test ' > Result: 'Test' |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target text string. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Remove spaces included in the specified text string (“ Test ”) and output the result in a message box.
String_Trim Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_String
Used variables
None
Used properties
[Output] Result =
RESULTdata = ' Test '
Xml_GetValueByXpath
Xml_GetValueByXpath
Overview
This activity card fetches an Xpath value from a specified XML text string.
Application procedures
In the [Output] Result field, enter the variable to store the searched Xpath value.
In the data field, enter a target XML string.
In the xPath field, enter the Xpath value to search for.
Card output properties
Property | Type | Additional comments | Description | Example |
|---|---|---|---|---|
String | - | Finds and returns the value corresponding to xPath in the specified data . | Harry Potter29.99 |
Card input properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
N | [ARGUMENTS] data | String | Y | - | N | Enter the target XML string. |
N | [ARGUMENTS] xPath | String | Y | - | N | Enter the Xpath value to search for. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Example of utilization
Fetch the Xpath element corresponding to “book” from the XML string stored in the “xml_data” variable and output it in a message box.
Xml_GetValueByXpath Sample
Sample file
Menu > Help > Sample > Sample > DataConverter > Example_XML
Used variables
this.xml_data = Variable that stores the XML string (Default: '<?xml version="1.0" encoding="UTF-8"?> <bookstore> <book> <title lang="en">Harry Potter</title> <price>29.99</price> </book> <book> <title lang="en">Learning XML</title> <price>39.95</price> </book> </bookstore>')
Used properties
[Output] Result =
RESULTdata =
this.xml_dataxPath = 'book'
Remarks
In the data field, an XML object or XML string must be entered.
Related/Similar activities
Xml_ToString
Xml_ToString
Overview
This activity card converts the specified XML object into a text string.
Application procedures
In the [Output] Result field, enter the variable to store the converted text string.
In the data field, enter a target XML object.
Card properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
Y | Variable | Y | - | Y | Enter the variable to store the converted text string. | |
N | [ARGUMENTS] data | Variable | Y | - | N | Enter the XML object to convert. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Remarks
In the data field, an XML object or XML string must be entered.
Related/Similar activities
Xml_ToXmlDocument
Xml_ToXmlDocument
Overview
Parses the specified XML string and converts it to an XmlDocument object.
Application procedure
In [Output] Result , enter a variable to store the value converted into XMLDocument.
In data , enter the target XML string.
Card properties
Common | Properties | Type | Required | Unit | Auto-settings | Description |
|---|---|---|---|---|---|---|
Y | Variable | Y | - | Y | Enter a variable to store the value converted to XMLDocument. | |
N | [ARGUMENTS] data | Variable | Y | - | N | Enter the XML object to convert. |
Y | - | - | - | - | Common property of the DataConverter library. | |
Y | - | - | - | - | Common property of the DataConverter library. |
Remarks
The data attribute value must be an XML string.
Related/Similar activities
Base64__EncodeFile
Base64__EncodeFile
Overview
This activity card converts the specified file to a Base64 string.
Application procedure
In [Output] Result field, enter a variable to store the value converted to Base64 string.
In path field, enter the path of the file to encode.
Card properties
Common | Properties | Type | Required | Unit | Auto-setting | Description |
|---|---|---|---|---|---|---|
Y | [Output] Result | Variable | Y | - | Y | Enter a variable to store the value converted to a Base64 string. |
N | [ARGUMENTS] path | Variable | Y | - | N | Enter the path of the file to encode. |
Y | - | - | - | - | Common properties of the DataConverter library. | |
Y | - | - | - | - | Common properties of the DataConverter library. |
Example of utilization
After reading the 'image.jpg' binary file and converting it to a base64 string, the result is output to the message box.
base64_en
Sample file
Menu > Help > Samples > Sample > DataConverter > DataConverter > Example_Base64
Used variables
NA
Used properties
[Output] Result = RESULT
path = 'D:\\image.jpg'