<?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 Your expression should not… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Collection-Filter-Use-Mid/m-p/76446#M28945</link>
    <description>Your expression should not have quotation marks around it.&amp;nbsp; &amp;nbsp; From your description you should have something more like this as your expression in a dedcision stage:&amp;nbsp;Mid([Producer Code], 2, 6)=""ABCDEF""
&amp;nbsp;
I strongly recommend that people use the expression builder functionality in the Decision/Calculation stage to build their expressions if they are not sure of Blue Prism syntax.</description>
    <pubDate>Fri, 27 Apr 2018 13:54:00 GMT</pubDate>
    <dc:creator>Denis__Dennehy</dc:creator>
    <dc:date>2018-04-27T13:54:00Z</dc:date>
    <item>
      <title>Collection Filter - Use Mid()</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-Filter-Use-Mid/m-p/76445#M28944</link>
      <description>I have a collection with field (text) named [Producer Code], now i want to filter this collection where the&amp;nbsp;2nd to&amp;nbsp;7th characters are "ABCDEF"&amp;nbsp;in [Producer Code], how to write this filter. "ABCDEF" may appear at anywhere,but they are not what i want except for the&amp;nbsp;2nd to 7th.

&amp;nbsp;

I&amp;nbsp;entered a filter as below, but system indicate : The expression contains undefined function call Mid().

"Mid([Producer Code], 2, 6)='"&amp;amp;[ProducerCode]&amp;amp;"'"</description>
      <pubDate>Tue, 24 Apr 2018 13:59:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-Filter-Use-Mid/m-p/76445#M28944</guid>
      <dc:creator>EricLi</dc:creator>
      <dc:date>2018-04-24T13:59:00Z</dc:date>
    </item>
    <item>
      <title>Your expression should not…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-Filter-Use-Mid/m-p/76446#M28945</link>
      <description>Your expression should not have quotation marks around it.&amp;nbsp; &amp;nbsp; From your description you should have something more like this as your expression in a dedcision stage:&amp;nbsp;Mid([Producer Code], 2, 6)=""ABCDEF""
&amp;nbsp;
I strongly recommend that people use the expression builder functionality in the Decision/Calculation stage to build their expressions if they are not sure of Blue Prism syntax.</description>
      <pubDate>Fri, 27 Apr 2018 13:54:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-Filter-Use-Mid/m-p/76446#M28945</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-04-27T13:54:00Z</dc:date>
    </item>
  </channel>
</rss>

