ERRORCONTAINS
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
Syntax
ERRORCONTAINS(possibleError:<Any>;string:<string>)
Description
- returns FALSE if 'possibleError' is not an ERROR value
- returns TRUE if the ERROR message of 'possibleError' contains the 'string', returns FALSE otherwise
- a NULL 'stringValue' results in a FALSE value
Example
ERRORCONTAINS(#B;'failed')
| A | B | ERRORCONTAINS |
|---|---|---|
| 0 | <error> | true |
| 1 | 5.0 | false |
| 2 | 2.5 | false |
| 3 | 1.6666 | false |
| 4 | 1.25 | false |