<?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 It worked how expected… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72975#M25580</link>
    <description>It worked how expected. Thank you so much.</description>
    <pubDate>Tue, 24 Jul 2018 16:24:00 GMT</pubDate>
    <dc:creator>MareenFlemming</dc:creator>
    <dc:date>2018-07-24T16:24:00Z</dc:date>
    <item>
      <title>Extract special text</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72970#M25575</link>
      <description>Hi guys,

I have another question for blueprism. I have to extract special text. The trigger to start the process is an E-Mail. In that E-Mail there is a text with a Standard form like this:

&amp;nbsp;

"Bitte ablegen.

Engagement Name: Testengagement 2018 Robot

Version: 2018V1

&amp;nbsp;

Mit freundlichen GrÃ¼ÃŸen,"

I have to extract and save the underlined text in a data type. The text can have different characters lenght.

Thanks in advanced.
Mareen</description>
      <pubDate>Fri, 20 Jul 2018 17:58:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72970#M25575</guid>
      <dc:creator>MareenFlemming</dc:creator>
      <dc:date>2018-07-20T17:58:00Z</dc:date>
    </item>
    <item>
      <title>With a calculation stage,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72971#M25576</link>
      <description>With a calculation stage, you can use the InStr formula to find the position of ""Engagement Name:"" and ""Version:"". The underlined text should be between those two, it doesn't matter if it's on a different line.</description>
      <pubDate>Fri, 20 Jul 2018 18:41:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72971#M25576</guid>
      <dc:creator>MelissaSuarez_G</dc:creator>
      <dc:date>2018-07-20T18:41:00Z</dc:date>
    </item>
    <item>
      <title>Thanks Melissa, I will try…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72972#M25577</link>
      <description>Thanks Melissa, I will try it and let you know if it is working for me or not.</description>
      <pubDate>Fri, 20 Jul 2018 18:54:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72972#M25577</guid>
      <dc:creator>MareenFlemming</dc:creator>
      <dc:date>2018-07-20T18:54:00Z</dc:date>
    </item>
    <item>
      <title>I tried this
 
InStr(…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72973#M25578</link>
      <description>I tried this
&amp;nbsp;
InStr([Message Body]; ""Engagement Name:"" AND ""Version:"")
&amp;nbsp;
And I'm getting an error: Internal : Failed to evaluate expression 'InStr([Message Body]; ""Engagement Name:"" AND ""Version:"")' - Both operands for 'AND' must be flags.
&amp;nbsp;
What does it mean?</description>
      <pubDate>Fri, 20 Jul 2018 19:06:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72973#M25578</guid>
      <dc:creator>MareenFlemming</dc:creator>
      <dc:date>2018-07-20T19:06:00Z</dc:date>
    </item>
    <item>
      <title>I don't think you can use…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72974#M25579</link>
      <description>I don't think you can use AND inside the InStr formula.
I tried this one and it works:
Mid([Message Body], InStr([Message Body], ""Engagement Name:"") + 17, InStr([Message Body], ""Version:"") - InStr([Message Body], ""Engagement Name:"") - 20 )
Please note:
The +17 is because ""Engagement Name:"" has 17 characters, so adding those characters to the formula tells BP that you want the text after the end of that string.
Similar with the -20 at the end of the formula, the InStr will find&amp;nbsp;""Version:"" but you don't want to extract that word nor the spaces before it.
You might need to adjust the 17 and the -20 depending on the actual format of the email; if you have a HTML email for example, you might get tags like "", but if you adjust the 17 and 20 you should be ok.</description>
      <pubDate>Sat, 21 Jul 2018 17:38:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72974#M25579</guid>
      <dc:creator>MelissaSuarez_G</dc:creator>
      <dc:date>2018-07-21T17:38:00Z</dc:date>
    </item>
    <item>
      <title>It worked how expected…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72975#M25580</link>
      <description>It worked how expected. Thank you so much.</description>
      <pubDate>Tue, 24 Jul 2018 16:24:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Extract-special-text/m-p/72975#M25580</guid>
      <dc:creator>MareenFlemming</dc:creator>
      <dc:date>2018-07-24T16:24:00Z</dc:date>
    </item>
  </channel>
</rss>

