<?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 Replace single quotation in Replace() in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Replace-single-quotation-in-Replace/m-p/55134#M9528</link>
    <description>Hello,

I'm attempting to replace a " with a blank space in a string using the Replace() function.  I have tried the following

Replace([steInput], ", "")

Error Message - Data items must be between [ and ]. Text must be between " and ". Functions should be in the form functionname()

Replace([steInput], ", "")

Error Message = Data items must be between [ and ]. Text must be between " and ". Functions should be in the form functionname()

Replace([steInput], """, "")

Test - a"a  Result - a"a

Replace([steInput], """, "")

Test a"a  Result - a"a

Any help would be appreciated !

Thanks</description>
    <pubDate>Mon, 14 Nov 2016 14:23:00 GMT</pubDate>
    <dc:creator>Stephen.Jones</dc:creator>
    <dc:date>2016-11-14T14:23:00Z</dc:date>
    <item>
      <title>Replace single quotation in Replace()</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Replace-single-quotation-in-Replace/m-p/55134#M9528</link>
      <description>Hello,

I'm attempting to replace a " with a blank space in a string using the Replace() function.  I have tried the following

Replace([steInput], ", "")

Error Message - Data items must be between [ and ]. Text must be between " and ". Functions should be in the form functionname()

Replace([steInput], ", "")

Error Message = Data items must be between [ and ]. Text must be between " and ". Functions should be in the form functionname()

Replace([steInput], """, "")

Test - a"a  Result - a"a

Replace([steInput], """, "")

Test a"a  Result - a"a

Any help would be appreciated !

Thanks</description>
      <pubDate>Mon, 14 Nov 2016 14:23:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Replace-single-quotation-in-Replace/m-p/55134#M9528</guid>
      <dc:creator>Stephen.Jones</dc:creator>
      <dc:date>2016-11-14T14:23:00Z</dc:date>
    </item>
    <item>
      <title>Found the answer !</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Replace-single-quotation-in-Replace/m-p/55135#M9529</link>
      <description>Found the answer !
Replace([SteInput], """""""", """")</description>
      <pubDate>Mon, 14 Nov 2016 15:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Replace-single-quotation-in-Replace/m-p/55135#M9529</guid>
      <dc:creator>Stephen.Jones</dc:creator>
      <dc:date>2016-11-14T15:01:00Z</dc:date>
    </item>
  </channel>
</rss>

