Functions Reference

Replace(“William”;3;4;”NEW TEXT”) returns WiNEW TEXTm.
Replace(PhoneNumber;1;3;”415”) returns 415-555-9054, when the PhoneNumber
field contains 408-555-9054.
Right
Format
Right(text;numberOfCharacters)
Parameters
text - any text expression or text field
numberOfCharacters - any numeric expression or field containing a number
Data type returned
text
Description
Returns the specified numberOfCharacters in text, counting from the right.
Examples
Right(“Manufacturing”;4) returns ring.
Right(Name;Length(Name) - Position(Name;“ “;1;1)) returns Cannon,
when the Name field contains Michelle Cannon.
Right(SerialNumber;3) & Upper(Left(LastName;4)) returns 187FERR when
the SerialNumber text field contains 00-48-187 and LastName contains Ferrini.
RightValues
Format
RightValues(text;numberOfValues)
Parameters
text - any text expression or text field
numberOfValues - any numeric expression or field containing a number
See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text