Filemaker Upgrade to FileMaker Pro 8.5 VLA Tier 2 + Maintenance TG782Z/A Manuel D’Utilisation
Codes de produits
TG782Z/A
Chapter 12
|
Text functions 175
Examples
LeftWords(“Plaid Canvas Suitcase”;2) returns
Plaid Canvas
.
LeftWords(Name;1) returns
Sophie
, when the Name field contains Sophie Tang.
Length
Format
Length(field)
Parameter
field - any text, number, date, time, timestamp, or container
or numeric expression
Data type returned
number
Description
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.
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.
Lower
Format
Lower(text)
Parameter
text - any
Data type returned
text
Description
Returns all letters in text as lowercase.