Consider the following array of data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange” ,”EggPlant”,”Kale”,”Bananas”). What function would you use to replace “EggPlant” with “Brinjal” AND “Kale” with “SomeGreenThing”?

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

Leave a Reply