Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
2 years ago

Alphabetize a List?

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
------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    2 years ago

    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
    ------------------------------