11 Replies Latest reply on Feb 9, 2016 6:52 AM by rickaltman

    Add an "and" to a list


      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