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

    Bug with substitute function and quote character char(34)

    MacEasy

      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

       

      Thanks