Filemaker Pro 8.5 Educational Maintenance T2 TJ085LL/A 用户手册
产品代码
TJ085LL/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)