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 |