Reference > Functions reference > Text functions > Length
 
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