Length
Purpose
Returns the number of characters in a field, including all spaces, numbers, and special characters.
Format
Length(field)
Parameters
field - 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.
Examples
Length(“John”) returns 4.
Length(Description) returns 12 when the value in Description is Modem for PC.
Length(“M1” & Left(Product;5)) returns 7, when the Product field contains Canvas Backpack.
Related topics