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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.