Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Sorting and skipping "The"

Solved
Jump to Solution
1091 2
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Joel_D_Eon
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Nov 10, 2020 07:25 AM

Hello,
Is there a way to sort by name, but ignore “The” in the sort calculation. I am trying to sort albums with a Artist + Album field and would like the sorting to ignore “The” in the artist name.

0 Kudos
Reply
1 Solution

Accepted Solutions
Joel_D_Eon
4 - Data Explorer
4 - Data Explorer
In response to Bill_French
Solved See Solution in Thread

‎Nov 10, 2020 10:48 AM

Thank You. I used the Substitute formula and that worked

See Solution in Thread

Reply
2 Replies 2
Bill_French
17 - Neptune
17 - Neptune
See Solution in Thread

‎Nov 10, 2020 10:25 AM

Hi Joel, and welcome to the community!

Yes, briefly…

  1. Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
  2. Sort on the formula field.
0 Kudos
Reply
Joel_D_Eon
4 - Data Explorer
4 - Data Explorer
In response to Bill_French
Solved See Solution in Thread

‎Nov 10, 2020 10:48 AM

Thank You. I used the Substitute formula and that worked

Reply
Copyright © 2025 Khoros, LLC
Top