======Replace(text, old_text, new_text) ====== Category: Text function \\ =====Description===== This function replaces all instances of //old_text// with //new_text// within //text//. \\ =====Arguments===== ^Argument^Type^Description^ |text|Text|Any text value or value that can be implicitly converted to text.| |old_text|Text|The text to be found within //text// and replaced by //new_text//, if found.| |new_text|Text|The text that replaces //old_text// if found within //text//.| **Return value type:** Text \\ =====Remarks===== This function is case sensitive. Entering '' (two single quotes; an empty string) as the //new_text// value has the same effect as using the [[syntax:functions:removetext|RemoveText]] function. Number values entered for //text//, //old_text//, and //new_text// are implicitly converted to text. \\ =====Examples===== replace('Food & Beverage', '&', 'and') //Returns 'Food and Beverage' replace('New York', 'york', 'Orleans') //Returns 'New York' ('york' isn't found due to the case of 'y'.) replace('New Mexico', ' ', '_') //Returns 'New_Mexico' (Replaces spaces with underscores.) replace(123456789, 456, 654) //Returns '123654789' (Number implicitly converted; return value is text.) replace(190091, "00", 5) //Returns '19591' (Enter multiple zeroes as text; return value is text.) \\ =====See also===== * [[syntax:functions:regexreplace|RegExReplace(text, replace_text, regex_text)]] * [[syntax:functions:removetext|RemoveText(text, string)]]