4 Replies Latest reply on Jun 18, 2015 11:30 PM by Tableau kumar

    substituting lower case to capital letters

    Young Song

      Hey all,

       

           Is there a way to substitute lower case to capital letters?  For example, from "chicken" to "Chicken"

       

           I was thinking something in the lines of using LEFT() and Replace() to do this.  Something like:

       

           IF LEFT("chicken",1) IS A LOWERCASE THEN REPLACE(LEFT("chicken",1), UPPER(LEFT("chicken",1)))

       

            So to be more specific, I am looking for a way to check if a character is upper or lower case.

       

      Thank you

       

          Young