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 ---------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHow 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
------------------------------
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
------------------------------
- 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
------------------------------- MarkShnier__Youdid you try it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- At the time of posting I hadn't... did a quick test... using your formula and mine to populate IfUpper and IfLower:
------------------------------
Ryan Stanford
------------------------------
