Char() can't find some unicode characters
Operating system version
OS X 10.6.8
Description of the issue
I get a string from a ODBC query. The string contains some invisible characters Unicode/Ascii = 11 (VT, Vertical Tab).
I wish to get these characters with Char(11), and then sustitute them.
But the Char(11) function doesn't work.
FilMaker do not recognize these characters, some Ascii = 13 or Ascii = 10 are displayed instead.
Eporting the string field to a plain text file, and inspecting it, I still see the Ascii = 11 character anyway.
How can I get rid of it?
Steps to reproduce the problem
import in the field "TextField" a string that contains the Ascii = 11 character.
Set the calculated field "TextFieldFiltered".
TextFieldFiltered= CercaeSost( TextField ; Char (11) ; Char (13) )
(I don't know the english name of the "CercaeSost" formula)
nothing for now. I'll give a try to troi plugin.