{"id":805,"date":"2014-08-19T00:01:00","date_gmt":"2014-08-19T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2014\/08\/19\/powershell-mini-scripting-games-2014-answer-2\/"},"modified":"2014-08-19T00:01:00","modified_gmt":"2014-08-19T00:01:00","slug":"powershell-mini-scripting-games-2014-answer-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powershell-mini-scripting-games-2014-answer-2\/","title":{"rendered":"PowerShell Mini-Scripting Games 2014: Answer 2"},"content":{"rendered":"

Summary<\/b>: Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014.<\/span>\nMicrosoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline<\/a>.<\/p>\n

Problem 2 synopsis<\/h2>\n

You have a CSV file that contains five columns. It comes from the HR department and it contains information that you do not need. You only need to work with three of the columns.<\/p>\n

Moving forward<\/h3>\n

As I said, it could be a bear to solve this problem, unless you remember that when imported, a CSV file produces objects. Therefore, all I need to do is to use the Select-Object<\/b> cmdlet to select the columns I need, and export the file back to a CSV file. Here is a simple CSV file that I can use:<\/p>\n

Fname,Lname,Group,Phone,Email<\/p>\n

adam,adams,admin,555-1212,aa@contoso.msft<\/p>\n

betty,barnes,business,555-1213,bb@contoso.msft<\/p>\n

charlie,cassidy,customer relations,555-1214,cc@contoso.msft\nLet’s say that I need the Fname<\/b>, Lname<\/b>, and Email<\/b> from this file. All I need to do is to import the CSV file, select the three fields I want, and then export the file back out. Here is how I do it:<\/p>\n

Problem2Answer.ps1<\/p>\n

Import-Csv C:DataInp2.csv |<\/p>\n

Select-Object Fname, Lname, Email |<\/p>\n

Export-Csv C:DataOutp2Groomed.csv -Append -NoTypeInformation\nThe groomed data is shown here:<\/p>\n

“Fname”,”Lname”,”Email”<\/p>\n

“adam”,”adams”,”aa@contoso.msft”<\/p>\n

“betty”,”barnes”,”bb@contoso.msft”<\/p>\n

“charlie”,”cassidy”,”cc@contoso.msft”\nThat is all there is to solving Problem 2. Mini-Scripting Games Answer Week will continue tomorrow when I will talk about the answer to Problem 3.\nI invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.\nEd Wilson, Microsoft Scripting Guy<\/b> <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline. Problem 2 synopsis You have a CSV file […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[191,169,521,3,4,45],"class_list":["post-805","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-community","tag-csv-and-other-delimited-files","tag-mini-scripting-games","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Here is the answer to Problem 2 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Problem 2 could be a bear to solve. After all, it involves text manipulation. Last week, I posted the complete Problem 2 description and task outline. Problem 2 synopsis You have a CSV file […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=805"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/805\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}