Hi, I am using sorttextarray(pv!test, false) to sort a list of text

Hi,

I am using sorttextarray(pv!test, false) to sort a list of text array(username ie Frist name+ " "+Lastname), its not sorting text if it has a "." or just first name in the string is there anyway to fix this?, please do find the screenshot for the same below.

OriginalPostID-207497

OriginalPostID-207497

  Discussion posts and replies are publicly visible

Parents
  • @sathisht How about using sort()?

    sort({"Tammy Page","Teresa Croce","kalpana.mayuluri","Thane S Thurmond","Thomas Zebovitz","Tina M Walker","VANAND","Vanee Komolprasert","Vivian M Gilliam","WTROTTER","Weifeng Li","kalpana.mayuluri","Ischlappal","sathish.thulukanam"}) => Ischlappal; kalpana.mayuluri; kalpana.mayuluri; sathish.thulukanam; Tammy Page; Teresa Croce; Thane S Thurmond; Thomas Zebovitz; Tina M Walker; VANAND; Vanee Komolprasert; Vivian M Gilliam; Weifeng Li; WTROTTER

    FYI, reverse(sort()) gives you descending order.
Reply
  • @sathisht How about using sort()?

    sort({"Tammy Page","Teresa Croce","kalpana.mayuluri","Thane S Thurmond","Thomas Zebovitz","Tina M Walker","VANAND","Vanee Komolprasert","Vivian M Gilliam","WTROTTER","Weifeng Li","kalpana.mayuluri","Ischlappal","sathish.thulukanam"}) => Ischlappal; kalpana.mayuluri; kalpana.mayuluri; sathish.thulukanam; Tammy Page; Teresa Croce; Thane S Thurmond; Thomas Zebovitz; Tina M Walker; VANAND; Vanee Komolprasert; Vivian M Gilliam; Weifeng Li; WTROTTER

    FYI, reverse(sort()) gives you descending order.
Children
No Data