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 [email protected].") returns a list of one item: [email protected]
EXTRACTEMAILS("Mailing List: [email protected], [email protected], [email protected]") returns a list of three items: [email protected], [email protected], [email protected].
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