Is there a way to sort by alpha and ignore the articles ("the", etc.)?
Is there a way to sort, say, "Film Titles," for example, and have the sort ignore articles like "the" and "a" and "an" (without having to list a title as "Bourne Identity, The" for example
5 replies
-
Yes, but you'll need to add a field to your table that you will sort by. In Table view you can move the new field off screen so it isn't seen. In Form view you can set the "Display field only, if:" to null to hide it. The easiest way is to use a Formula field and a formula like this...
extractx('Film Titles', "(?:a|an|the) (.+)", "i", "$1")Just copy and paste the formula to the Formula field.
-
Sorry, I should have tested more thoroughly. This line fixes the problem of not display records without a starting article, but I'm still seeing issues with the sorting.
extractx(Text, "(?:an|a|the )?(.+)", "i", "$1") -
This appears to fix the sorting issue...
extractx(Text, "(?:a |an |the )?(.+)", "i", "$1") -
My apologies for not replying sooner. Thanks for your help. I'm still not getting it to work, but I'll keep fudging with it. Thanks again.
-
No worries. Are you getting an error? What do you see in the Formula field?
Content aside
- 4 yrs agoLast active
- 5Replies
- 576Views