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”?
- A) REPLACE
- B) SUBSTITUTE
- C) SUBSTITUTE_REGEX
- D) REPLACE OR SUBSTITUTE
- E) All of the above