Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change apple to *pple AND banana to b*n*n*?

✅  The correct answer is:

SUBSTITUTE

Question:

Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change apple to *pple AND banana to b*n*n*?

Solution:

  • SUBSTITUTE
  • SUBSTITUTE_REGEX
  • REPLACE OR SUBSTITUTE
  • REPLACE
  • All of the above