Description
Attempts extract a clean email address from a given input value
Syntax
CLEANEMAILADDRESS(<input>)
Arguments
Argument | Type | Description | Optional |
---|---|---|---|
input | Text | The text/email address to clean. | No |
Returns
Text
Examples
Expression: | CLEANEMAILADDRESS(" Fred.Bloggs@gmail.com") |
Returns: | fred.bloggs@gmail.com |
Expression: | CLEANEMAILADDRESS("Fred Bloggs <Fred.Bloggs@gmail.com>") |
Returns: | fred.bloggs@gmail.com |