Powershell Meeting: Garbage In Garbage Out with Ed Wilson

Ed Wilson, “The Scripting Guy” from Microsoft will be here to help us kick off the PowerShell User Group. If you would like to see future meetings, place your vote by showing up for this meeting! Everyone has heard the old adage, “garbage in, garbage out” when talking about databases, or other online data storage / retrieval systems. But do you know that Windows PowerShell can help you with your problem? In this session, Microsoft Scripting Guy Ed Wilson, talks about using Windows PowerShell to perform data grooming. He shows how cleaning up names, street addresses, cities, states, and even zip codes by using basic string manipulation techniques. By focusing directly on the data transformation itself, he extracts principles that can be used regards of the database, or other data storage system. After focusing on the individual components of the process, he puts the whole thing into a single script for transforming the sample data. This session is heavy with live demonstration.