Discussions

Expand all | Collapse all

Data Validation: Is there a capital letter

  • 1.  Data Validation: Is there a capital letter

    Posted 18 days ago
    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 18 days ago
    Edited by Mark Shnier (YQC) 18 days 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
    ------------------------------



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

    Posted 18 days ago
    Edited by Ryan Stanford 18 days 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
    ------------------------------



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

    Posted 18 days ago
    did you try it?

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



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

    Posted 18 days ago
    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 17 days ago
    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
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



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

    Posted 17 days ago
    Ryan,

    Good trick.  Thanks for the tip.


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