KNOWLEDGE BASE

NULL Result When Using REGEXP_EXTRACT


Published: 17 Jul 2018
Last Modified Date: 04 Jan 2019

Issue

When using the following regular expression: REGEXP_EXTRACT, the field returns Null values. 

Environment

Tableau Desktop

Resolution

Either the data does not match the Regular Expression string, or the Regular Expression string is incorrect.

For example, if REGEXP_EXTRACT([username], '(e)') returns Null, the [username] field may not contain any records with 'e' in them.

Cause

Null is returned when the Regular Expression string does not have a match.
Did this article resolve the issue?