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