4 Replies Latest reply on Jan 16, 2014 11:27 PM by Birdys

    How do I exclude "blanks" from sorting



      How do I exclude "blanks" from sorting


           One of the reports that I import from a third party (ASCAP) may list a song title with a variety of blank spaces after the text.  When I sort by Title, the blanks are considered in the sort, so what appears to be identical field text actually is recognized as different text values.  How do I exclude blank spaces from sorting?