KNOWLEDGE BASE

NULL Result When Using REGEXP_EXTRACT


Published: 17 Jul 2018
Last Modified Date: 18 Jul 2018

Issue

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

Environment

Tableau Desktop 2018.2.1

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.

Additional Information

For assistance on regular expression syntax, see your data source's documentation. For additional information about regular expressions, see the following third party websites: 
Did this article resolve the issue?