EVL – ETL Tool


Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2023 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents

Logical Functions

is_equal

(since EVL 2.7)

is_equal(value1,value2)

return TRUE if ‘value1’ is equal to ‘value2’ or if both are null, otherwise it is FALSE. ‘value’s might be also pointers. For example following example is applicable:

is_equal(in->value_field1, in->value_field2)

is_in

(since EVL 2.4)

is_in(value, compare1, compare2, ...)

return TRUE if ‘value’ is equal ‘compare1’ or equal to ‘compare2’, etc., otherwise it is FALSE. ‘value’ doesn’t need to be the same data type as compared values, but must be comparable. ‘value’ and also compared list of values might be also pointers. For example following example is applicable:

is_in(in->some_uint, 123, in->some_long, 12.00, nullptr)
is_in(value, vector)

return TRUE if ‘value’ is equal at least one of the ‘vector’ elements, otherwise it is FALSE.

is_valid_<type>

(since EVL 1.0)

is_valid_char(str)
is_valid_uchar(str)
is_valid_short(str)
is_valid_ushort(str)
is_valid_int(str)
is_valid_uint(str)
is_valid_long(str)
is_valid_ulong(str)

to check if given string ‘str’ is valid integral data type,

is_valid_float(str)
is_valid_double(str)

to check if given string ‘str’ is valid float or double,

is_valid_decimal(str,m,n,dec_sep,thous_sep)

to check if given string ‘str’ is valid decimal number with precision ‘m’ and scale ‘n’, and with decimal separator ‘dec_sep’ and thousand separator ‘thous_sep’,

is_valid_date(str,format)
is_valid_datetime(str,format)
is_valid_timestamp(str,format)

to check if the given string ‘str’ is valid date and time data type in specified ‘format’,

is_valid_ipv4(str)
is_valid_ipv6(str)

(since EVL 2.4)
to check whether the string ‘str’ is valid IPv4 or IPv6.