FILEMAKER: The Right, RightValues And RightWords Functions

From Dwayne Wright - www.dwaynewright.com

The right family of functions are used to break text strings up, starting from the right of a specified position. This is a common technique called parsing.

Right
Right( text ; numberOfCharacters)
FMP Version: FMP 7 and FMP 6
Used to return characters from the right of a text string or field by a determined amount. For instance Right(LeSaux, 2) would equal ux.

RightValues
RightValues( text ; numberOfValues)
FMP Version: FileMaker 7
This function will pull a number of data strings from a number of carriage returns. Used frequently to parse out each line of an array.

EXAMPLE:
RightValues(values_list; values_variable)
This example allows you to use a field ( values_variable ) to choose how many values to the right of the end of the string will be returned.

RightWords
Rightwords( text ; numberOfWords)
FMP Version: FMP 7 and FMP 6
Used to return words from the right of a text string or field by a determined amount. For instance RightWords(LeSaux Media Services, 2) would equal Media Services.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.