Replaces part of a text string with a new text string.
REPLACE( [ Original Text], [ Start Position], [ Number of Characters], [ Replacement Text] )
Original Text is the string that you want to replace characters in.
Start Position is the position of the character in Original Text, that you want to start replacing from.
Number of Characters is the number of characters in the Original Text, that you want to replace with the Replacement Text.
Replacement Text is the string of characters that will replace the chosen characters in Original Text.
|REPLACE(CustomerNameTextBoxReturn, 6, 5, NewSurnameTextBoxReturn)||Replaces five characters, starting at the sixth character in the CustomerNameTextBoxReturn string, with the return value from the NewSurnameTextBox.|
Number of Characters
Result of the REPLACE function
|"John Smith"||6||5||"Harrison"||John Harrison|
|"Sandra King"||8||4||"Thompson"||Sandra Thompson|