AnsweredAssumed Answered

Reorder text from result of List(FieldName function)

Question asked by osninc on Jun 23, 2017
Latest reply on Jun 23, 2017 by philmodjunk



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.