eqlin_ci(X;Y)
Returns a boolean value indicating whether the value of the first argument is equal to (one of the values of) the second and is case insensitive. (Available as of version 12.34)
Syntax
eqlin_ci(X;Y)
Input
Argument | Type | Description |
---|---|---|
X |
text | A scalar expression or column expression |
Y |
text | A scalar expression or column expression
|
Return Value
Returns a boolean value of 1
or 0
indicating whether or
not X
is equal to (one of the values in) Y
.
The data type of the result is integer.
If X
and Y
are both N/A, the result is
1
; if only one is N/A, the result is 0
.
Sample Usage
value |
list |
eqlin_ci(value;list) |
---|---|---|
'abcdefg' | 'abcDEfg' | 1 |
'abcdefg' | 'Abc' 'def' | 0 |
'abc' | 'ABC' 'def' 'Hij' | 1 |
'NY' | 'Ny' 'Ca' 'Ma' | 1 |
'abc' | 0 | |
1 |