Extracts text between two specified separators. If there are multiple matches, returns them all separated by commas in a single text output. For instance, given text that is a comma-separated list of email addresses, you could use this function to get back a comma-separated list of domain names.
Options
- End Of Value: Choose from the list the character(s) that specify where to end the text you are looking to extract, e.g. a space, period, comma, or all of the above.
Input Fields
key text: a value to look for inside of analyze text that specifies where to begin the text extraction (this value is not included in the output text). It can be a single character like
@(for extracting domain names from email) or could be a key phrase such asName:that signals where to find the text you are looking to extract.analyze text: the text to look inside of.
Output Fields
- all: the text value extracted from the analyze text or multiple text values separated by commas in a single text output.
Examples
If End of Value is (space), key text is @ and analyze text is support@company.com, then all is company.com.
If End of Value is , (comma), key text is @ and analyze text is support@company1.com,contact@company2.com, then all is company1.com,company2.com.
If End of Value is . (period), key text is @ and analyze text is support@company.com, then all is company.
If End of Value is . (period), key text is @ and analyze text is support@company1.com,contact@company2.com, then all is company1,company2.