Skip to main content
Question

Alphabetize a List?

  • May 1, 2023
  • 0 replies
  • 95 views

Forum|alt.badge.img+20

I can usually alphabetize a list getting creative with a Combined Text Summary field. However, I have a unique situation where I have a Summary Field (that I have already alphabetized) and I need to put it in a list with one more value. But I need this value to fit in the correct spot to make this whole list alphabetized. 

Example:
Combined Text Field  = A;B;C;E;F;G
Extra Field = D

Desired outcome: A;B;C;D;E;F;G



------------------------------
Mike Tamoush
------------------------------

Forum|alt.badge.img+20
  • Author
  • Registered
  • May 1, 2023

Ive done it manually because I only will have a max of 8 fields in my Combined Text Field, but it's not very elegant. Solution below if anyone needs it, but hopefully someone has a more elegant solution.

var text CombList = ToText([Combined Text Field]);
var text FD = ToText([Extra Field to Fit In]);

var text PartOne = Trim(Part($CombList,1,";"));
var text PartTwo = Trim(Part($CombList,2,";"));
var text PartThree = Trim(Part($CombList,3,";"));
var text PartFour = Trim(Part($CombList,4,";"));
var text PartFive = Trim(Part($CombList,5,";"));
var text PartSix = Trim(Part($CombList,6,";"));
var text PartSeven = Trim(Part($CombList,7,";"));
var text PartEight = Trim(Part($CombList,8,";"));

If(
$FD<$PartOne, List("<br>", $FD, $PartOne, $PartTwo, $PartThree, $PartFour, $PartFive, $PartSix, $PartSeven, $PartEight),
$FD>$PartOne and $FD<$PartTwo, List("<br>",$PartOne, $FD, $PartTwo, $PartThree, $PartFour, $PartFive, $PartSix, $PartSeven, $PartEight),
$FD>$PartTwo and $FD<$PartThree, List("<br>",$PartOne, $PartTwo, $FD,  $PartThree, $PartFour, $PartFive, $PartSix, $PartSeven, $PartEight),
$FD>$PartThree and $FD<$PartFour, List("<br>",$PartOne, $PartTwo, $PartThree, $FD, $PartFour, $PartFive, $PartSix, $PartSeven, $PartEight),
$FD>$PartFour and $FD<$PartFive, List("<br>",$PartOne, $PartTwo, $PartThree, $PartFour, $FD, $PartFive, $PartSix, $PartSeven, $PartEight),
$FD>$PartFive and $FD<$PartSix, List("<br>",$PartOne, $PartTwo, $PartThree, $PartFour, $PartFive, $FD, $PartSix, $PartSeven, $PartEight),
$FD>$PartSix and $FD<$PartSeven, List("<br>",$PartOne, $PartTwo, $PartThree, $PartFour, $PartFive, $PartSix, $FD, $PartSeven, $PartEight),
$FD>$PartSeven and $FD<$PartEight, List("<br>",$PartOne, $PartTwo, $PartThree, $PartFour, $PartFive, $PartSix, $PartSeven, $FD, $PartEight),
$FD>$PartEight, List("<br>",$PartOne, $PartTwo, $PartThree, $PartFour, $PartFive, $PartSix, $PartSeven, $PartEight, $FD)
)



------------------------------
Mike Tamoush
------------------------------