Filemaker Upgrade to FileMaker Pro 8.5 VLA Educational Tier 5 + Maintenance TJ965Z/A Manual Do Utilizador
Códigos do produto
TJ965Z/A
182 FileMaker Functions Reference
Description
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.
numberOfCharacters characters. Compare to the Substitute function.
Examples
Replace(“1234567”;5;1;“X”) returns
1234X67
.
Replace(“1234567”;5;1;“XX”) returns
1234XX67
.
Replace(“1234567”;5;2;“X”) returns
1234X7
.
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
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)