<?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 The tldr; is that you need… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73726#M26331</link>
    <description>The tldr; is that you need to use named groups in your regex&amp;nbsp;and pass a collection with those names defined&amp;nbsp;in the collection.
&amp;nbsp;
The long of it:
First, you need to modify your regex to capture the result in a ""Named Group"".&amp;nbsp; (You can google ""regex named groups if you are unfamiliar with this concept.) Using your shortened regex, something like this should work:
""\s(?CT|MA|ME|NH|NY|RI|VT)\s\s""
&amp;nbsp;
Then you need to create a collection (refered to as ""NamedValues"" for reference). This collection NamedValues needs to have two fields defined, both as type Text:
&amp;nbsp;&amp;nbsp;Field 1) Name
&amp;nbsp;&amp;nbsp;Field 2) Value
Now, pre-populate NamedValues with one row for every named group you want to capture and fill in the ""Name"" field with the names used in a regex named group.&amp;nbsp; In this example we're only looking for state, so you would have just one row with Name set to State.&amp;nbsp; Leave the field Value as empty.
Now, in your ""Extract Regex Values"" action,&amp;nbsp;update the input fields to include the collection NamedValues&amp;nbsp;(in the input field ""Named Values"").&amp;nbsp;And update the output field ""Named Values"" to pass to either the same collection, or a collection with the same form (or no definition).
That should be it.&amp;nbsp; Cheers
&amp;nbsp;
&amp;nbsp;</description>
    <pubDate>Thu, 21 Feb 2019 07:50:00 GMT</pubDate>
    <dc:creator>JasonEtchason</dc:creator>
    <dc:date>2019-02-21T07:50:00Z</dc:date>
    <item>
      <title>How to use Extract Regex Values Action</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73724#M26329</link>
      <description>I am facing an issue with using the Extract Regex Values action.&amp;nbsp; There is very limited documentation provided for this action.&amp;nbsp; I've done some research and made some progress, but I am not able to make the last connections to solve this problem.&amp;nbsp; I'm hoping someone will be able to help, and I thank you all in advance.

I am able to generate a Regex pattern that extracts the correct data from my Target String, but I am unable to get it to work within Blue Prism.&amp;nbsp; From my research, it appears that I need to reference the value that I'm looking for in the Regex pattern itself.&amp;nbsp; I€™m not sure how to do that, and could use some direction.

My Target String is a multi-line, variable text string called "Address Block".&amp;nbsp; Here's an example:

"&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; JAMES JOHN JONES JR&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 135 GRANDERSON AVE&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ANYTOWN&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; NY&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 99999&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

"

I am trying to extract the 2-character State ("NY" in the example above), which I am calling Address State.&amp;nbsp; I have referenced Address State in the Name field on the Initial Values tab of my input collection "Named Values".&amp;nbsp; My Regex pattern (shortened for readibility) is "\s(CT|MA|ME|NH|NY|RI|VT)\s\s".&amp;nbsp; Results are output to the same collection "Named Values".

My question is: How do I reference Address State in this Regex pattern, so that the Extract Regex Values action will work properly?

Thank you.

Peter Lomi</description>
      <pubDate>Wed, 20 Feb 2019 19:09:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73724#M26329</guid>
      <dc:creator>PeterLomi</dc:creator>
      <dc:date>2019-02-20T19:09:00Z</dc:date>
    </item>
    <item>
      <title>The tldr; is that you need…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73725#M26330</link>
      <description>The tldr; is that you need to use named groups in your regex&amp;nbsp;and pass a collection with those names defined&amp;nbsp;in the collection.
&amp;nbsp;
The long of it:
First, you need to modify your use to capture the result in a ""Named Group"".&amp;nbsp; (You can google ""regex named groups if you are unfamiliar with this concept. Using your shortened regex, something like this should work:
""\s(?CT|MA|ME|NH|NY|RI|VT)\s\s""
&amp;nbsp;
Then you need to create a collection (refered to as ""NamedValues"" for reference). This collection NamedValues needs to have two fields defined, both as type Text:
Field 1) Name
Field 2) Value
&amp;nbsp;
Now, pre-populate NamedValues with one row for every named group you want to capture and fill in the ""Name"" field with the names used in a regex named group.&amp;nbsp; In this example we're only looking for state, so you would have just one row with Name set to State&amp;nbsp;(minus quotes).&amp;nbsp; You can leave the field Value as empty here.
&amp;nbsp;
Now, in your ""Extract Regex Values"" action,&amp;nbsp;update the input fields to include the collection NamedValues&amp;nbsp;(in the input field ""Named Values"").&amp;nbsp;And update the output field ""Named Values"" to pass to either the same collection, or a collection with the same form (or no definition).
That should be it.&amp;nbsp; Cheers
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Thu, 21 Feb 2019 07:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73725#M26330</guid>
      <dc:creator>JasonEtchason</dc:creator>
      <dc:date>2019-02-21T07:46:00Z</dc:date>
    </item>
    <item>
      <title>The tldr; is that you need…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73726#M26331</link>
      <description>The tldr; is that you need to use named groups in your regex&amp;nbsp;and pass a collection with those names defined&amp;nbsp;in the collection.
&amp;nbsp;
The long of it:
First, you need to modify your regex to capture the result in a ""Named Group"".&amp;nbsp; (You can google ""regex named groups if you are unfamiliar with this concept.) Using your shortened regex, something like this should work:
""\s(?CT|MA|ME|NH|NY|RI|VT)\s\s""
&amp;nbsp;
Then you need to create a collection (refered to as ""NamedValues"" for reference). This collection NamedValues needs to have two fields defined, both as type Text:
&amp;nbsp;&amp;nbsp;Field 1) Name
&amp;nbsp;&amp;nbsp;Field 2) Value
Now, pre-populate NamedValues with one row for every named group you want to capture and fill in the ""Name"" field with the names used in a regex named group.&amp;nbsp; In this example we're only looking for state, so you would have just one row with Name set to State.&amp;nbsp; Leave the field Value as empty.
Now, in your ""Extract Regex Values"" action,&amp;nbsp;update the input fields to include the collection NamedValues&amp;nbsp;(in the input field ""Named Values"").&amp;nbsp;And update the output field ""Named Values"" to pass to either the same collection, or a collection with the same form (or no definition).
That should be it.&amp;nbsp; Cheers
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Thu, 21 Feb 2019 07:50:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73726#M26331</guid>
      <dc:creator>JasonEtchason</dc:creator>
      <dc:date>2019-02-21T07:50:00Z</dc:date>
    </item>
    <item>
      <title>Thank you for your help.  It…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73727#M26332</link>
      <description>Thank you for your help.&amp;nbsp; It was the Named Group part that I was missing.&amp;nbsp;</description>
      <pubDate>Sat, 02 Mar 2019 02:57:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/How-to-use-Extract-Regex-Values-Action/m-p/73727#M26332</guid>
      <dc:creator>PeterLomi</dc:creator>
      <dc:date>2019-03-02T02:57:00Z</dc:date>
    </item>
  </channel>
</rss>

