Loading

NULL Result When Using REGEXP_EXTRACT

Дата публикации: Apr 13, 2024
Описание
When using the following regular expression: REGEXP_EXTRACT, the field returns Null values. 

Cause

Null is returned when the Regular Expression string does not have a match.
Решение
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.
Дополнительные ресурсы
For assistance on regular expression syntax, see your data source's documentation. For additional information about regular expressions, see the following third party websites: 

Номер статьи базы знаний

001471543

 
Загрузка
Salesforce Help | Article