ERRORMATCHES

Owned by Juliane Wetzel

Apr 29, 2020

1 min read

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