<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Extract Regex Values - How to extract all the values that meet the pattern? in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Extract-Regex-Values-How-to-extract-all-the-values-that-meet-the/m-p/81923#M33437</link>
    <description>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</description>
    <pubDate>Wed, 23 Nov 2016 17:52:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-11-23T17:52:00Z</dc:date>
    <item>
      <title>Extract Regex Values - How to extract all the values that meet the pattern?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-Regex-Values-How-to-extract-all-the-values-that-meet-the/m-p/81923#M33437</link>
      <description>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</description>
      <pubDate>Wed, 23 Nov 2016 17:52:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-Regex-Values-How-to-extract-all-the-values-that-meet-the/m-p/81923#M33437</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-11-23T17:52:00Z</dc:date>
    </item>
  </channel>
</rss>

