.NODE

RightValues()

Category: Text

Syntax: RightValues ( text; numberOfValues )


Parameters:

textAny return-delimited text string or expression that generates a return-delimited string.

numberOfValuesAny positive number or expression that returns a positive number.

Data type returned: Text

Description:

Returns the specified number of items from the end of the text parameter.

The RightValues() function returns the last n items from a return-delimited array. The items themselves will be a return-delimited array, and there will always be a trailing return at the end of the last item.

See the LeftValues() function for a discussion of methods to remove the trailing return from the output of the RightValues() function.

Examples:

Function

Results

RightValues("A¶B¶C¶D¶E";3)

Returns the following:

 

C

 

D

 

E

RightValues(test;1)

Returns C when test contains

 

A

 

B

 

C




: 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

show all menu





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

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