Generic Import functions

Absolute

Calculates the absolute value of the input number.

Absolute (A)= |A|

string

Add

Adds two numbers.

Add (A,B) = A+B

string

And

Returns TRUE if all of the arguments evaluate to TRUE.

AND(True,True)= True

boolean

Concat

Concatenates the argument values into one text and returns with it.

concat(A,B,C)  =  ABC

string

Divide

Returns with the divided value of two numbers (A / B).

Divide (A,B) = A/B

string

Equal

Checks equality between two values (A = B)). Returns with a boolean result.

1 if true, 0 if false

boolean

Greater

Checks if the first parameter is greater than the second one (A > B). Returns with a boolean result.

1 if true, 0 if false

boolean

Greater or equal

Checks if the first parameter is greater or equal to the second one (A >= B). Returns with a boolean result.

1 if true, 0 if false

boolean

If

Based on the first logical parameter returns with the second or third parameter. If the logical value is TRUE then returns with the first parameter, otherwise with the second parameter.

if(condition, A, B) = A if true, B if false

string

Less

Checks if the first parameter is less than the second one (A < B). Returns with a boolean result.

1 if true, 0 if false

boolean

Less or equal

Checks if the first parameter is less or equal to the second one (A <= B). Returns with a boolean result.

1 if true, 0 if false

boolean

Mapping

Based on the first parameter value it finds a "Dictionary" key parameter in the given list and returns with its value.

Map(1, 1 ->odd, 2->even) = odd

string

Multiply

Returns with the multiplied value of two numbers (A * B).

Multiply (A,B) = A*B

string

Or

Returns TRUE if any argument evaluates to TRUE.

Or(True, False) = True

boolean

Regex

In the first parameter value run a regex search pattern from the second parameter. The first group match will be the output

regex(1234, \d{2}) = 12

string

Replace

In the first parameter, it searches a string from the second parameter and replaces with the third parameter.

replace(input,in,out) = output

string

Substring

Returns the portion of the string from the first parameter specified by the start and length parameters from the second and the third parameter.

substring(input data, 2,3)= put

string

Subtract

Subtracts the second number from the first number.

Subtract(A,B)=A-B