Jump to content

This topic is 6412 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.