RightWords()

Category: Text

Syntax: RightWords ( text; numberOfWords )


Parameters:

textAny expression that resolves to a text string.

numberOfWordsAny positive number or expression that returns a positive number.

Data type returned: Text

Description:

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

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, RightWords ("54.6"; 1) returns 54.6, but RightWords ("x.y"; 1) returns y. The reason for this behavior is that those symbols are valid date, time, and number separators.

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

Examples:

Function

Results

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

Returns brown fox jumps.

RightWords (FullName; 1)

Returns Smith when the FullName field contains Joe Smith.




: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

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