Hi,
When using Extract Regex Values action, I'm trying to solve a problem where I need to extract more than one values that meet the required pattern. Example:
--------------------------------
Payer: Acme inc
Address: onestreet 1
Invoice 12345 100,00+
Unstructured information...
Invoice 12355 200,00-
Unstructured information...
Invoice 40503 300,00+
Random information
etc.
--------------------------------
As a result, I would like to have a collection with three rows (there are three invoices) and two fields (I need invoice number and the sum).
Is it possible to find and extract all the results that meet the pattern by using Extract Regex Values? Currently it seems like the Extract Regex Values gives only the first finding in a way that invoice number and sum are in different rows.
Thank you!
Johan
