Add an "and" to a list

Discussion created by rickaltman on Feb 4, 2016
Latest reply on Feb 9, 2016 by rickaltman

I have a field that receives a bunch of first names from a portal, thanks to the List function. The result might look like this:


Alice, Bill, Chuck


However, I need for the list to read:


Alice, Bill, and Chuck



I need to find the last comma in the text and add an "and" to it. I have been messing around with the Position function stuffed inside of a Substitute function, but I can't get it right. Can someone help?





Rick A.
Pleasanton CA