LeftWords()

 <  Day Day Up  >  

LeftWords()

Category: Text

Syntax: LeftWords ( text ; numberOfWords )

Parameters: text ”any expression that resolves to a text field; numberOfWords ”any positive number or expression that returns a positive number.

Description: Returns the first n number of words in a text expression, where n is the number specified in the numberOfWords parameter.

Examples:

 

 LeftWords("the quick brown fox jumps" ; 3) 

Returns the quick brown .

 

 LeftWords(FullName ; 1) 

Returns Joe when FullName contains "Joe Smith" .

Comments:

Be aware of what symbols are considered to be word breaks by FileMaker Pro. Spaces, return characters , and most punctuation symbols are considered to be word breaks. Multiple word breaks next to each other (for example, two spaces, a comma and a space) are considered as a single word break.

Certain punctuation symbols are word breaks when separating alpha characters, but not when separating numeric characters. These include the colon (:), slash (/), period (.), comma (,), and dash (-). For instance, LeftWords ("54.6" ; 1) returns 54.6 , but LeftWords ("x.y" ; 1) returns x . The reason for this behavior is that those symbols are valid date, time, and number separators.

Leading and trailing punctuation around a word may be ignored by the LeftWords() function. For example, LeftWords ("John Q. Public, Jr."; 2) returns John Q , but LeftWords ("John Q. Public, Jr."; 3) returns John Q. Public .

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net