Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 12

  

|

  Text functions     175

LeftWords(“Plaid Canvas Suitcase”;2) returns 

.

LeftWords(Name;1) returns 

, when the Name field contains Sophie Tang.

Length(field)

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

 

or numeric expression

number

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

characters. For a container field, Length returns the total stored size of objects in bytes.

Length(“John”) returns 

.

Length(Description) returns 

 when the value in Description is Modem for PC.

Length(“M1” & Left(Product;5)) returns 

, when the Product field contains 

Canvas Backpack.

Lower(text)

text - any 

text

Returns all letters in text as lowercase.