beginswith_ci(X;L)
Returns a boolean value indicating whether a given string begins with any of the substrings in a given list and is case insensitive. (Available as of version 12.33)
Syntax
beginswith_ci(X;L)Input
| Argument | Type | Description |
|---|---|---|
X |
text | The string to search for in the items in the list LA scalar value or the name of a column |
L |
text | A space- or comma-separated list of text strings against which to compare
X |
Return Value
Returns an integer value of 1 if X begins with any of the strings in the
list L. Otherwise, returns 0.
If X is N/A, the result is 0.
Sample Usage
value |
list |
beginswith_ci(value;list) |
|---|---|---|
| 'banana' | 'abc' 'BAN' 'yz' | 1 |
| 'banana' | 'abc' 'yz' | 0 |
Example
In the "Sales Item Detail" table (pub.demo.retail.item), you can find only those rows whose SKUs start with either "96" or "3B". To do this, create a computed column and apply thebeginswith_ci(X;L) function to the
sku column, where L is the list containing the strings
'96' and
'3B':<base table="pub.demo.retail.item"/> <willbe name="example" value="beginswith_ci(sku;'96' '3B')"/>
For
those values in the sku column that begin with "96"
or "3B", the result is
1.
Otherwise, the result is 0.
You could then use the <sel>
operation to select only those rows where the example column equals
1.
<sel value="(example=1)"/>
The
results are those rows where the value in the sku column is
3B7, 969, or
96A.
Additional Information
beginswith_ci(X;L) is identical to beginswith(X;L) except
that it performs case-insensitive (in the English alphabet) comparisons.