Tips and Tricks

Returns a value where a specified character or term has been replaced with another value.


Replace( o, f, r )


o     Original Value
f     Character or term to find
r     Value to replace the found text with


The examples below manipulate a value returned from a data source so they appear clearer in the document.

Replace([q1.staffID], "STAFFNUM", "Staff Number - ")
Replace([q1.PhoneNumber]," ", "")

The replace function is useful for removing unwanted characters from strings, commonly used to cleanse data retrieved from other systems.

Related Articles

remove contains delete overrwrite