Extract list of domain values within a textual value
Returns a list of domains within the textual value.
Sample usage
EXTRACTDOMAINS("Contact AppSheet Support at support@appsheet.com.")
returns a list of one item: appsheet.com
EXTRACTDOMAINS("Mailing List: a@a.com, b@b.com, c.com")
returns a list of two items: a.com, b.com
.
EXTRACTDOMAINS([How can we contact you?])
returns a list of domains extracted from any email addresses the user entered in the How can we contact you?
column of the form.
Syntax
EXTRACTDOMAINS(text-to-extract-from)
text-to-extract-from
- Any textual value from which a list of domains are to be extracted.