Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
5 years ago

Data Validation: Is there a capital letter

Hi,

Subject is the request, i'd like to know a way to detect if there is a capital letter in any given text field. Has anyone solved this?

------------------------------
GMacri
------------------------------
Formulas and functions

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    How about this (not tested but it should work)

    IF([My Text Field], <> Upper([My Text Field]), "Data has Capitals!!  Please correct the error and attempt to save again.")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      5 years ago
      I don't think Mark's answer will fully work... as the only way that [Field] will equal Upper([Field]) is if every letter is capitalized... not if only one such as "Mark", it would have to be "MARK". 

      To get the desired effect would be to have:

      If([Field] <> Lower([Field]), "Field has a capital letter","There are no capital letters")

      ------------------------------
      Ryan Stanford
      ------------------------------