- REPLACE
- SUBSTITUTE
- SUBSTITUTE_REGEX
- REPLACE OR SUBSTITUTE
- All of the above
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”?
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”?