Length

Returns the number of characters in a field, including all spaces, numbers, and special characters.

Format 

Parameters 

text - any text, number, date, time, timestamp, or container field, or any text expression or numeric expression

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Description 

For a container field, Length returns the size of the original file in bytes.

Example 1 

Length ( "John" ) returns 4.

Example 2 

Length ( Description ) returns 12 when the value in Description is Modem for PC.

Example 3 

Length ("M1" & Left ( Product ; 5 ) ) returns 7, when the Product field contains Canvas Backpack.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas