AnsweredAssumed Answered

Char() can't find some unicode characters

Question asked by StefanoVignato on May 12, 2012
Latest reply on May 14, 2012 by StefanoVignato


Char() can't find some unicode characters


FileMaker Pro



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.