/
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.*')

ABERRORMATCHES
0<error>true
15.0false
22.5false
31.6666false
41.25false

Related content

ERRORMATCHES
ERRORMATCHES
More like this
ERRORCONTAINS
ERRORCONTAINS
More like this
ERRORCONTAINS
ERRORCONTAINS
More like this
ISERROR
More like this
IFERROR
More like this
IFERROR
More like this