2 Replies Latest reply: May 15, 2014 10:11 AM by Olly Bond RSS

    How to identify products in database registered in *all* UPPER case

    AlexM _

      Here's an interesting challenge: I've a cleansing project which requires me to identify all products within our database whose names are all in UPPER case from amongst those in correct Title (or Proper) case.

       

      (Note: Although these will need correction to Title case, that can't be done automatically since a number of names hold correct uppper case acronymns which shouldn't be converted.)

       

      Any creative suggestions? Thanks.

       

      Alex