Parse XML File with PowerShell and if a value is found, copy file to a new location [duplicate]

Question

I have an application that outputs XML files during the life of an event in the software. I need to parse the XML files and once certain text are matched, move the file to another folder

The file name format of each XML file is: Event Owner (MEMS), Year (2020) and serial number (00012345). The software will write same file multiple time throughout the event so I need to look for specific items before taking any action. I would prefer to do this in PowerShell if at all possible.

I need to find

 `<EventUnits>
      <Unit>
        <UnitCode>xxxxxxx></UnitCode>
</EventUnits>`

and

<EventDetails>
        <EventCompletedTime>YYYY-MM-DD HH:MM:SS</EventCompletedTime>
</EventDetails>

Once UnitCode equals one of 4 unit codes and EventCompleted has a valid date and time, the file is moved to a different folder.

Does this answer your question? Parsing xml using powershell There are a lot of posts that walks you through parsing xml in powershell. — Jawad
– Jawad, Commented Feb 24, 2020 at 23:09

nim · Accepted Answer · 2020-02-24 23:34:23Z

0

You can read in the the file contents, telling powershell that you expect the file to be xml on ingestion. Then you can just access the objects within. For example:

# read in the file contents of xml file
[xml]$fileContents = Get-Content 'C:\my\file\path.xml'

# you should now be able to access the contents of the file using dot notation
Write-Host $fileContents.EventUnits.Unit.UnitCode
Write-Host $fileContents.EventDetails.EventCompletedTime

This example assumes that

EventUnits and EventDetails are top-level nodes (not nested inside another xml node)
The file would absolutely be there. If you are not sure you can test for the existence of the file
The file will absolutely be in xml format

answered Feb 24, 2020 at 23:34

nim

574 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse XML File with PowerShell and if a value is found, copy file to a new location [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related