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