ERRORMATCHES
- Juliane Wetzel
Owned by Juliane Wetzel
Apr 29, 2020
Loading data...
Syntax
ERRORMATCHES(possibleError:<ANY>;regex:<String>)
Description
- returns FALSE if 'possibleError' is not an ERROR value
- returns TRUE if the ERROR message of 'possibleError' matches the 'regex', returns FALSE otherwise
- 'regex' must be a constant and be valid, an invalid regex results in a column level error
Example
ERRORMATCHES (#B;'.failed.*')
| A | B | ERRORMATCHES |
|---|---|---|
| 0 | <error> | true |
| 1 | 5.0 | false |
| 2 | 2.5 | false |
| 3 | 1.6666 | false |
| 4 | 1.25 | false |