I have written a lot of scripts that use .txt files to read or store data, but I have a need to read some information from an .xml file.\u00a0 This could be done by treating the file as a simple txt file, but it would require some pretty good filtering that is already a part of the xml file.\u00a0 A quick search helped me locate this article:<\/p>\n
http:\/\/blogs.msdn.com\/kalleb\/archive\/2008\/07\/19\/using-powershell-to-read-xml-files.aspx<\/a><\/p><\/blockquote>\n
Which contained the key to helping me with what I needed to do.\u00a0 The specific piece I needed was in Lesson 2:<\/p>\n
Lesson 2:
\nRead data from an XML-file.
\nThe XML-file that I’m going to read from has the following structure:
\n<Users>
\n\u00a0 <User>
\n\u00a0\u00a0\u00a0 <Name>Kalle<\/Name>
\n<\/User>
\n\u00a0 <User>
\n\u00a0\u00a0\u00a0 <Name>Becker<\/Name>
\n\u00a0 <\/User>
\n<\/Users>
\nReading data from an XML-file is really easy in PowerShell! Use this command to load the file into an variable:
\nPS C:\\Tmp> [xml]$userfile = Get-Content Accounts.xml <\/em><\/p>\nWhen the xml-file is loaded you can type “$userfile.U<\/em>” and press tab to get auto completion!! It’s a breeze.<\/p><\/blockquote>\n
The trick is that you have to actually READ what is in front of you.\u00a0 The key here is to let PowerShell know that you are reading an xml file, and that is done by placing [xml]<\/strong> prior to getting the content.\u00a0 I missed that the first six times I read this and couldn\u2019t figure out why I wasn\u2019t getting the results I expected.<\/p>\n","protected":false},"excerpt":{"rendered":"
I have written a lot of scripts that use .txt files to read or store data, but I have a need to read some information from an .xml file.\u00a0 This could be done by treating the file as a simple txt file, but it would require some pretty good filtering that is already a part… Continue reading Using XML in your PowerShell scripting<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[25],"tags":[135,154,201],"class_list":["post-207","post","type-post","status-publish","format-standard","hentry","category-scripting","tag-powershell","tag-scripting","tag-xml","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-3l","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}