rickaltman

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?

 

FMPA14

 

 

Rick A.
Pleasanton CA

Outcomes