| relationship |
eq, neq, stw, enw, con, num, eqi, neqi, lt, gt, lte or gte |
The relationships can be split up into string or numeric (even though they always get strings,
sometimes they must be converted to numbers):
string
- eq: True if the two strings are exactly the same (case sensitive), e.g. "hello" and "hello".
- neq: True if there is a difference between the two strings, e.g. "hello" and "goodbye".
- stw: True if the left string starts with the right string, e.g. "hello" and "he".
- enw: True if the left string ends with the right string, e.g. "hello" and "lo".
- con: True if the right string occurs anywhere in the left string, e.g. "hello" and "ell".
- num: True if the left string can be converted to a number, e.g. "-15.76". Note: no fractions.
Right string is ignored.
numeric
- eqi: True if the two numbers are equal by value, e.g. "0.76" and "00.760"
- neqi: True if there is any difference between the numbers, e.g. "0.76" and "0.67".
- lt: True if the left value is less than the right value, e.g. "0.4" and "0.76".
- gt: True if the left value is greater than the right value, e.g. "1.23" and "0.76".
- lte: True if the left value is less than or equal to the right value (eqi or lt).
- gte: True if the left value is greater than or equal to the right value (eqi or gt).
Note: if you try and use a numeric function on a non-numeric value, it will be set to 0.
|