Basic functions : REPLACE, SUBSTITUTE
When do we use REPLACE and when do we use SUBSTITUTE?
We will answer this question with some basic examples of both functions.
With REPLACE, we specify the position and lenght of the substring to be replaced, what that substring is, we don’t know.
With SUBSTITUTE, we know what we are replacing, just not sure exactly where it is in the target string.
