abailey3 Posted March 22, 2016 Posted March 22, 2016 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 Posted March 22, 2016 Posted March 22, 2016 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.
comment Posted March 22, 2016 Posted March 22, 2016 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now