Replace
Purpose
Replaces a string of characters in specified text with replacementText.
Format
Replace(text;start;numberOfCharacters;replacementText)
Parameters
text - any
text expression or text
field start - any numeric expression or field containing a number representing the starting position in text
numberOfCharacters - any numeric expression or field containing a number representing the number of characters to remove from text
replacementText - any text expression or field containing the text to replace in the original string
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Character replacement in text begins at the start character position and continues for 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.
Related topics