Uppercase cardinal directions

[abailey3]

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?

[jbante]

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.

[abailey3]

That works! Thank you!

[comment]

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.