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