Managing data inside a CSV file is surprisingly simple thanks to
the Import-CSV CmdLet. I’m often presented with data from
different sources in a variety of formats, and by and large the
common format used for data extracts is CSV. Regardless of the
system that generates the content, we can all render and consume
data using this simple and effective format. You will find the
Microsoft TechNet documentation here:
http://technet.microsoft.com/en-us/library/dd347665.aspx The
file that we will use as our example is one that contains a
username, email address, street address, postal code (zip code
for my US friends) and a phone number. This is what the file
would look like for our sample which will be named UserList.CSV:
ewright,Eric Wright,email@example.com,123 Any Street,L4C
1N8,555-1212 jvoigt,Jens
Voigt,firstname.lastname@example.org,456 Any Street,L4C
1N8,555-3456 ppocklington,Peter
Pocklington,email@example.com,890 Back Street,M2H 4Y1,555-9876
Note that there is a header row which is one of the most
importan