Generic Import functions

This article describes the supported functions fields in the Generic Import Source.

Function Type	Function description	Return value	Value type
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
Exists	Checks if a field exists in the input metadata. Returns TRUE if the field can be found/resolved and the value is not empty. FALSE otherwise.	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 it 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	string

VFC Capture (Verba) 9.9

Generic Import functions

Analytics

Related content