ERRORMATCHES
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 |