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

Summary

Char() can't find some unicode characters

Product

FileMaker Pro

Version

11.0v4

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)

Workaround

nothing for now. I'll give a try to troi plugin.

Outcomes