Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I've spent a lot of time searching for options on auto formatting "names" when entered into a record (i.e. ensuring that names are entered with correct case etc). I'm now familiar with many options from Proper function to "Better Proper" custom functions etc. Further I understand that you can never cover every possible scenario of case usage within names. So, I've decided to take another route, it seems simple, but I can't figure out how to do it.

What I'm trying to do:

I need a script step that will simply "catch" any name field that does not start with an uppercase letter. At that point I'll just have custom dialogue pop up that says "Double check last name...you may have missed typed" (or something to that effect). I'm versed enough to handle all of the script except the "catch" portion. I can't figure out the correct statement to catch the first letter being lowercase?

Any/all help is appreciated. Thanks.

Posted

Let( x= Left( last name; 1) ;

  Exact( x; Upper( x) ) )

The result will be 1 if first letter is uppercase, 0 if not.

Posted

Fitch...thank you that works great. I also appreciate the comment about the numeric and/or special character comment, if anyone reads this and has a tweak that would catch non-alpha and/or special characters as well those suggestions are welcome.

Posted

You can look at it from the opposite direction:

Let (

firstChar = Left ( LastName ; 1 )

;

Exact ( firstChar ; Lower ( firstChar ) )

)

will return 1 (True) unless the first character is a genuine upper-case character.

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