One for the formula field experts who like a challenge!
I've been trying to write a formula field to replace all instances of "X" with "Y" within the source multiline text field - where X and Y are strings.
My specific use case is to replace all instances of "£" with "£" (see http://www.w3schools.com/html/html_entities.asp for background as to why I need to do this if interested - the data feeds out of Quickbase to elsewhere, hence why I need to convert it)
The input field can be any length, and quite long, and can therefore contain many instances of the £ sign.
However, realistically for the purposes of the formula, it would probably be safe to assume there would be no more than 10 instances of "X" in the input field.
Ideally I need the solution to be based purely on native Quickbase formula field methodologies (sorry Dan!).