Which function replaces occurrences of a value with a new value in a string?

Which function replaces occurrences of a value with a new value in a string?

• A. Replace
• B. Position
• C. Substring
• D. Mid

Answer: (A)

Replacing occurrences of a value with a new value in a string is substitution. The Replace function searches the string for every instance of the value you want to change and returns a new string where those instances are swapped with the new value. For example, replacing 'apple' with 'fruit' in 'apple banana apple' yields 'fruit banana fruit'. The other options don’t perform substitution: Position tells you where a substring starts, while Substring (or Mid) extracts a portion of the string rather than changing it.

Replacing occurrences of a value with a new value in a string is substitution. The Replace function searches the string for every instance of the value you want to change and returns a new string where those instances are swapped with the new value. For example, replacing 'apple' with 'fruit' in 'apple banana apple' yields 'fruit banana fruit'. The other options don’t perform substitution: Position tells you where a substring starts, while Substring (or Mid) extracts a portion of the string rather than changing it.