Home > Reference > Functions reference > Text functions > Char

Char

 

Purpose 

Returns the characters for the Unicode code points in the number.

Format 

Char(number)

Parameters 

number - a decimal number representing one or more Unicode code points

Data type returned 

text

Originated in 

FileMaker Pro 10.0

Description 

Each group of five digits in the number is treated as a Unicode code point, and the character for each five-digit group is returned in the text.

If the number is 0, the function returns an empty string.

If the number is between 1 and 99,999, the function returns a single character.

If the number contains more than five digits, the function returns the string of characters represented by those code points.

Note  Some Unicode characters can be represented by a single code point or multiple code points. For example, the character ä can be represented by the letter a plus ¨ (dieresis) or by the single character ä. The single code point version of this kind of character is called a precomposed character or a composite character.

Examples 

Char(0) returns an empty string (“”).

Char(97) returns a.

Char(98) returns b.

Char(9800097) returns ab.

Char(228) returns ä.

Char(77600097) returns ä. In this case the number represents two Unicode characters: the letter a and the dieresis character. When these two characters appear together in a string they are displayed as a single character.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas