syntax:functions:in
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
syntax:functions:in [2016/06/20 11:24] – dmitry | syntax:functions:in [2021/08/16 04:34] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== In(value, values, separator) ===== | + | ====== In(text, look_in, delimiter) ====== |
+ | Category: | ||
- | Returns either | + | \\ |
+ | =====Description===== | ||
+ | This function returns Boolean | ||
- | Values in the delimited string are always considered text, even if they look like a number. | + | \\ |
+ | =====Arguments===== | ||
+ | ^Argument^Type^Description^ | ||
+ | |text|Text|Any text value or a value than can be implicitly converted to text.| | ||
+ | |look_in|Text (delimited values)|A list of values, separated by // | ||
+ | |delimiter|Text|The character or characters (it can be more than one character) used to separate the individual\\ values within the //look_in// argument.| | ||
+ | **Return value type:** Boolean (TRUE/ | ||
- | ^ Example | + | \\ |
- | | in(' | + | =====Remarks===== |
+ | This function is case sensitive. | ||
- | === See also === | + | Be careful when selecting the delimiting character(s) to use. If any of the values in //look_in// have this character/ |
- | | + | |
- | * [[syntax: | + | \\ |
- | * [[transformations: | + | =====Examples===== |
+ | in( ' | ||
+ | |||
+ | in( ' | ||
+ | |||
+ | |||
+ | \\ | ||
+ | To use this function with column references, concatenate the // | ||
+ | in( [TestValue], | ||
+ | |||
+ | \\ \\ | ||
+ | **Caution: | ||
+ | |||
+ | **Sample dataset: | ||
+ | ^TestValue | ||
+ | |North-West | ||
+ | |||
+ | If the function is configured as follows, using ' | ||
+ | in( [TestValue], | ||
+ | |||
+ | The embedded dashes (' | ||
+ | ' | ||
+ | ...and no match will be made. | ||
+ | |||
+ | \\ | ||
+ | ===== See also ===== | ||
+ | | ||
+ | * [[syntax: | ||
+ | * [[transformations: |
syntax/functions/in.1466436260.txt.gz · Last modified: 2016/06/20 11:24 by dmitry