Build expressions that return a list

The following expressions return lists as their result:

• EXTRACT() - List of recognizable elements from textual value.
• EXTRACTDATES() - List of dates from textual value.
• EXTRACTDATETIMES() - List of date-times from textual value.
• EXTRACTDURATIONS() - List of durations from textual value.
• EXTRACTEMAILS() - List of email addresses from textual value.
• EXTRACTHASHTAGS() - List of hashtags from textual value.
• EXTRACTMENTIONS() - List of mentions from textual value.
• EXTRACTNUMBERS() - List of numeric values from textual value.
• EXTRACTPHONENUMBERS() - List of phone numbers from textual value.
• EXTRACTPRICES() - List of prices from textual value.
• EXTRACTTIMES() - List of times from textual value.
• FILTER() - List of select rows in table.
• INTERSECT() - List of items common to two lists.
• LIST() - New list of values.
• ORDERBY() - List of rows in custom order.
• REF_ROWS() - List of rows referencing this row.
• SELECT() - List of column values from select rows.
• SORT() - List of items in order.
• SPLIT() - List of elements from textual value.
• TOP() - List of initial items of list.
• UNIQUE() - List of items with duplicates removed.

See also

List expressions