/
ERRORMATCHES
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 |
, multiple selections available,
Related content
ERRORMATCHES
ERRORMATCHES
More like this
ERRORCONTAINS
ERRORCONTAINS
More like this
ERRORCONTAINS
ERRORCONTAINS
More like this
ISERROR
ISERROR
More like this
IFERROR
IFERROR
More like this
IFERROR
IFERROR
More like this