Hey all,
I have data in a db table which I need to update into lowercase where applicable. When users have entered data in the past some have entered data which is either all in uppercase or only part are in uppercase.
i.e. I went to the doctor today AND HE SAID I WAS NOT ill
I am wandering if anyone knows of the regular expression to find words in string like the above on and if they contain two or more consecutive uppercase letters then correct it by putting the first letter in uppercase and the rest in lowercase?
Sorry my regular expression is shocking to say the least, and have tried researching this but have had no luck so far.
Any help is much appreciated.
Thanks
...
Go to the complete details ...