5 Replies Latest reply on Jun 23, 2017 2:20 PM by philmodjunk

    Reorder text from result of List(FieldName function)

    osninc

      Hi,

       

      I have a calculation field that uses List(FieldName) on two related portal fields and concatenates the result using "," vs  "¶".  The return now correctly combines the two fields as follows: A,B,C,D,1,2,3,4. I am trying to figure out how to reorder as A,1,B,2,C,3,D,4.  Any suggestions on how this can be done in a calculation field?  I don't always know how many values will be in the related record, it may be 0, 1, 10 etc.

       

      Thanks,

       

      Tom