Value Extraction

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 as Name: 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.