You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Number list

The function returns a STRING value in value_list that is in the same position as key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then the element of value_list is in position count(key_list) + 1.

Syntax
getMatchingValue(string key, string list key_list, number list value_list) #Output: String
Examples
Parser expressionDescription
getMatchingValue("Spain", ["USA", "UK", "France", "Spain", "Germany"], ["Washington", "London", "Paris", "Madrid", "Berlin"])

The function returns a STRING : "Madrid".

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER LIST


The function returns a NUMBER representing the numeric value in value_list that is in the same position as string key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list, then the element of value_list  is in position count(key_list) + 1.

Syntax
getMatchingValue(string key, string list key_list, number list value_list) #Output: number
Examples
Parser expressionDescription
getMatchingValue("Three", ["One", "Two", "Three", "Four", "Five"], [1, 1+1, 3*1, 4, 4+1])

The function returns a NUMBER : 3

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


Returns a NUMBER representing the numeric value in value_list that is in the same position as numeric key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list, then the element of value_list is in position count(key_list) + 1.

Syntax
getMatchingValue(string key, number list key_list, number list value_list) #Output: Number
Examples
Parser expressionDescription
getMatchingValue(5, [1, 3, 5, 7, 9], [1, 1+1, 3*1, 4, 4+1])

The function returns a NUMBER : 3

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


Returns numeric value in value_list that is in the same position as numeric key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list, then the element of value_list in position count(key_list) + 1.

Syntax
getMatchingValue(string key, number list key_list, number list value_list) #Output: Number
Examples
Parser expressionDescription
getMatchingValue(5, [1, 3, 5, 7, 9], [1, 1+1, 3*1, 4, 4+1])

The function returns a NUMBER : 3

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


Text list

The function returns a TEXT value in value_list that is in the same position as text key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then, the element of value_list in position count(key_list) + 1 .

Syntax
getMatchingValue(text key, string list key_list, text list value_list)#Output: Text 
Examples
Parser expressionDescription
getMatchingValue("Spain", ["USA", "UK", "France", "Spain", "Germany"], ["Washington", "London", "Paris", "Madrid", "Berlin"])

The function returns a TEXT : "Madrid"

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER


The function returns a TEXT value in value_list that is in the same position as the numeric key is in key_list, or in case key doesn't exist in key_list and value_list has more elements than key_list then, the element of value_list in position count(key_list) + 1 .

Syntax
getMatchingValue(text key, text list key_list, text list value_list) #Output: Text
Examples
Parser expressionDescription
getMatchingValue(8, [2, 4, 6, 8, 10], ["Washington", "London", "Paris", "Madrid", "Berlin"])

The function returns a TEXT : "Madrid"

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.
Output

The function returns a NUMBER