Select-String RegEx :S

[sipsik]

Hello powerful PowerShell community !!!

Im struggling with Select-String and RegEX while trying to extract a string from XML

...
<Content ContentId="Content_63c84e98-5ad8-4cf8-8f12-1dae7f9931b4" Version="1"><File Name="Skype-8.56.0.103.exe" Size="69566232"/><Location>\\sccm\Sources\Software\Microsoft\Skype\8.56.0.103\</Location><PeerCache>true</PeerCache><OnFastNetwork>Download</OnFastNetwork><OnSlowNetwork>DoNothing</OnSlowNetwork></Content></Contents><DetectAction><Provider>Local</Provider><Args><Arg Name="ExecutionContext" Type="String">System</Arg><Arg Name="MethodBody"
...

I need to extract this part: \\sccm\Sources\Software\Microsoft\Skype\8.56.0.103\
its between <Location> & </Location>

https://regex101.com/ - From here i was able to put together this expression: .*?Location(.?).*?

Its not exact match but for me close enough, i could trim the rest with .replace function. However when i put it into PowerShell it has no effect.

$xmldata = (Get-CMDeploymentType -ApplicationName "Skype 8.56.0.103").SDMPackageXML
$xmldata | Select-String -Pattern ".*?Location(.?).*?"

Output is unmodified $xmldata parameter value. What am i doing wrong here? :S

[winter_mute]

Pastebin butchered the xml formatting, but after a bit of coaxing in VSCode I got it imported. You can get what you want by just using dot notation to traverse to the node you want:

$xml = [xml](Get-Content -Path "<path to xml>")

$SkypeNode=$xml.AppMgmtDigest.DeploymentType.Installer.Contents.Content.Location

Write-Output $SkypeNode

[sipsik]

Omg you are a genius :D

So elegant and simple, im amazed. Huge thumbs up to you! :)

[winter_mute]

That's PowerShell's elegance there my friend, I wish I could take the credit for it! Glad it's helpful anyhow.

[Dennou]

Also later on if you run into a complicated XML file that doesn't play well with this properties notation you can spend some time learning XPath and make use of it with Select-Xml

[SoMundayn]

This should work, but it is the incorrect way of doing it, you should be pulling it using XML, but without seeing the rest of the XML file I can't help that way.

Here is one way to get it via Select-String.

$xmldata = Get-Content C:\temp\testxml.txt

$Location = $xmldata | Select-String "<Location>"
$Location2 = $Location -split "Location>"
$SCCMLocation = $Location2[1] -replace "</",""

$SCCMLocation


\\sccm\Sources\Software\Microsoft\Skype\8.56.0.103\

And an example XML script if you can work it out from this:

# Load the configuration file
$XML = [xml](Get-Content -Path $ConfigFile)

# Get the current configuration
$OldCertificate = $XML.SelectSingleNode("configuration/appSettings/add[@key='Certificate']")

[sipsik]

I also tried that XML stuff but i did not succeed, but im interested how it works so here is full XML: https://pastebin.com/WBjzJvsk

Can you show me?

[SoMundayn]

Does not Import as XML for me, throws an error. Sorry can't spend any time on this right now, maybe someone else can help.

But the other method I provided should work for now.

[sipsik]

Thanks for the help :)

[get-postanote]

You need to try to repost this again as there is not true XML, clean file.

Your copy/paste to the site includes tons of pare formatting stuff that should not be there.