AnsweredAssumed Answered

help with list calculation

Question asked by kilbot on Oct 2, 2012
Latest reply on Oct 22, 2012 by philmodjunk

Title

help with list calculation

Post

     Is there a way to write this list function to place "and" prior to the last field?

     Example (This is what the calculation does at this time):

     apple, milk, cherry

     I would like it to do:

     apple, milk and cherry

This is my calculation

Substitute ( List ( field) ; ¶ ; ", ")

Outcomes