Wickerman Posted September 14, 2007 Posted September 14, 2007 I wish there were an option in FMP's 'Sort' feature that would alphabetize a text field in the standard library manner that omits "A, An and "The" -- and perhaps allow the user to add other initial words to ignore. This would seem to be a fairly common need! Wickerman
David Jondreau Posted September 14, 2007 Posted September 14, 2007 But there is such an option. Create a calculated field that checks the first word of a field and if it meets your "A", "An", "The" test then omits that word (or appends it to the end of the field with an appropriate comma and space) and sort on that.
Recommended Posts
This topic is 6412 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now