Home > Reference > Functions reference > Text functions > Code

Code

Purpose 

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

Format 

Code(text)

Parameters 

text - one or more characters

Data type returned 

number

Originated in 

FileMaker Pro 10.0

Description 

Returns the Unicode code points for the characters in text. If zero characters are in text, returns an empty string.

If one character is in the text, the function returns the code point for that character. If the text contains multiple characters, the Unicode code point for each character is returned as a group of five digits where the code point for the first character is represented by the low five digits, the code point for the second character in the next higher (to the left) five digits, and so forth.

When converting a composite character such as ä, the function returns the Unicode code point for the composite character.

The following table shows how navigational characters are reported to a script activated by this trigger:

 

Key Pressed	Is reported as	Notes
backspace	8	Corresponds to Unicode/ASCII code for BS (backspace)
tab	9	Corresponds to Unicode/ASCII code for HT (horizontal tab)
shift-tab	9	The shift can be detected using the value returned from the Get(TriggerModifierKeys) function
enter	10	Corresponds to Unicode/ASCII code for LF (linefeed)
return	13	Corresponds to Unicode/ASCII code for CR (carriage return)
escape	27	Corresponds to Unicode/ASCII code for ESC (escape)
left arrow	28	Corresponds to Unicode/ASCII code for FS (file separator)
up arrow	29	Corresponds to Unicode/ASCII code for GS (group separator)
right arrow	30	Corresponds to Unicode/ASCII code for RS (record separator)
down arrow	31	Corresponds to Unicode/ASCII code for US (unit separator)
space	32	Corresponds to Unicode/ASCII code for Space
forward delete	127	Corresponds to Unicode/ASCII code for Delete

Note  If there are too many characters to be represented in the FileMaker number field type, the function returns a NaN (Not a Number) value.

Examples 

Code(“”) returns an empty string.

Code(“a”) returns 97.

Code(“b”) returns 98.

Code(“ab”) returns 9800097.

Code(“ä”) returns 228.

Code(“ä”)(an a followed by a dieresis character entered in a separate keystroke) returns 77600097.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas