# Discussions

View Only

## Data Validation: Is there a capital letter

• #### 1.  Data Validation: Is there a capital letter

Posted 11-25-2019 13:21
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
------------------------------

• #### 2.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 13:35
Edited by Mark Shnier (YQC) 11-25-2019 13:35

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
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

• #### 3.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 14:56
Edited by Ryan Stanford 11-25-2019 14:59
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
------------------------------

• #### 4.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 15:01
did you try it?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

• #### 5.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 15:51
At the time of posting I hadn't... did a quick test... using your formula and mine to populate IfUpper and IfLower:

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

• #### 6.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 19:38
Ryan, you were correct

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

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

• #### 7.  RE: Data Validation: Is there a capital letter

Posted 11-25-2019 21:18
Ryan,

Good trick.  Thanks for the tip.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------