10 Replies Latest reply on Aug 19, 2014 8:14 AM by MacEasy

    Bug with substitute function and quote character char(34)


      So I ran into an interesting little problem today.

      I'm doing an exact search (==) in a field in a script and it was failing because the users are entering values with a quote in them


      For example they might enter into the field

      The length is 12" long


      So then if you need to do an exact search

      "==" & $fieldcontents it doesn't work.


      No problem, we actually just have to escape for the quote symbol with "


      But there in lies the problem the substitute function won't substitute.


      So try this if you don't believe me, where char(34) = quote (") and char(92) = escape symbol ()

      Substitute("12" & Char(34);Char(92) & Char(34);Char(34))


      this should return 12/", but instead returns 12"

      If you use patterncount, it sees the quote symbol.


      Now I have a work around... I can run a loop using the replace function and that seems to do the trick, because it doesn't seem to be afflicted by the same issue.


      Anyone else run into this? and find a fix?

      Test in FM12v4 advanced and FM13v3