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
The correct answer is:
- SUBSTITUTE.
🎓 Get all the latest and 100% correct Klipfolio Expert Certification Exam Answers