Filemaker Pro 8.5 Advanced Maintenance TG762Z/A User Manual

Replaces a string of characters in text with replacementText. Character replacement 

in text begins at the start character position and continues for 
numberOfCharacters characters. Compare to the Substitute function.

Replace(“1234567”;5;1;“X”) returns 

.

Replace(“1234567”;5;1;“XX”) returns 

.

Replace(“1234567”;5;2;“X”) returns 

.

Replace(“William”;3;4;”NEW TEXT”) returns 

.

Replace(PhoneNumber;1;3;”415”) returns 

, when the PhoneNumber 

field contains 408-555-9054.

Right(text;numberOfCharacters)

text - any 

numberOfCharacters - any numeric expression or field containing a number

text

Returns the specified numberOfCharacters in text, counting from the right.

Right(“Manufacturing”;4) returns 

.

Right(Name;Length(Name) - Position(Name;“ “;1;1)) returns 

, 

when the Name field contains Michelle Cannon.

Right(SerialNumber;3) & Upper(Left(LastName;4)) returns 

 when 

the SerialNumber text field contains 00-48-187 and LastName contains Ferrini.

RightValues(text;numberOfValues)