Learn about Windows PowerShell
Summary: Learn how to use Windows PowerShell to easily capitalize a string.
How can I use Window PowerShell to make all the text upper case so it is all in the same form prior to writing to a database?
Use the ToUpper method from the String class:
The ToUpper() and ToLower() methods on Strings are great for ensuring consistency. I have also found that converting to Proper Case can be useful.
I had to do some data cleanup in the past few months for a client and was using "tolower()" on a regular basis to see if names matched up. Some were all UPPER, some were MiXeD and some were lower.
I love the fact that this sits in the Console and I can just test with it live too :)