Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I need to be able to uppercase all cardinal directions (NW, SE, etc) in an address field. I have this resolved using a Perform Find/Replace step for when these occur in the middle of a field ("[space]NW[space]"). However, often these occur to the far right of a field. Is there an easy way to simply uppercase the last two characters in a field without changing anything else that's been entered?

Posted

Let ( [
    _left = Left ( Table::field ; Length ( Table::field ) - 2 ) ;
    _right = Right ( Table::field ; 2 )
] ;
    _left & Upper ( _right )
)

Note that this doesn't help you identify which records to apply this to.

Posted
39 minutes ago, abailey3 said:

I have this resolved using a Perform Find/Replace step for when these occur in the middle of a field ("[space]NW[space]").

In Find/Replace, you have the option to Match whole words only.

This topic is 3237 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.