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.
remove contains delete overrwrite