Sorting on a calculated value

[btmeacham]

This seems like it should be simple, but I can't seem to figure it out. Thanks to this solution

 

http://fmforums.com/forum/topic/68663-sorting-titles-ignoring-the-a-an/

 

I created a field that stripped all of the leading articles from titles I'd like to sort. The calculation works properly, and the resulting "Sort Field" with no leading articles looks right.

 

Then I ran a sort on that field... and found that the titles still aren't sorting properly. This sounds so basic, I'm not even sure how to explain it any further, but the sort I'm getting is only slightly different than what I get when I leave the records unsorted, and I see them simply in the order they were entered. It's not exactly the same, though; one or two records move around, but overall, it's not sorted in the "alphabetical order disregarding leading articles" way one would expect.

 

Is there some step I'm missing? Is there any way something could be hidden in my calculation field that causes FileMaker not to sort on it in the way that seems obvious? Thanks for your help.

[No_access]

Can you confirm the the sort field is in fact a text field? or that the calculation result is set to text?

[btmeacham]

Remember the part where I said it was probably simple? I will never again forget to make sure the result is set to be text. I promise. Thanks!

[Lee Smith]

Don't be too upset, this happens to all of us.