AnsweredAssumed Answered

How do I exclude "blanks" from sorting

Question asked by Birdys on Jan 16, 2014
Latest reply on Jan 16, 2014 by Birdys


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?