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