Extracting values from string in PowerShell (with Regex)

Question

I have the following file:

<Mapping ServerPath="$/Test/Dev/test/sunday/project" LocalPath="$(SourceDir)\Test" Version="Latest" WorkspaceMappingType="Map">
<Mapping ServerPath="$/Test/Dev/test/aaa/project2" LocalPath="$(SourceDir)\Test\project" Version="Latest" WorkspaceMappingType="Map">
<Mapping ServerPath="$/Test/Dev/test/sunday/project/test" LocalPath="$(SourceDir)\Test-machine" Version="Latest" WorkspaceMappingType="Map">
<Mapping ServerPath="$/Test/Dev/test/besaide/monday" LocalPath="$(SourceDir)\Monday" Version="Latest" WorkspaceMappingType="Map">

I need to extract from each line these 2 values:

ServerPath="$/Path"

LocalPath="$(SourceDir)\Path"

I have the file content in PS variable with this method:

$file = Get-Content C:\test\file.txt

Now how can I retrieve the 2 valus from each line with Regex? (or without Regex if it possible).

Mathias R. Jessen · Accepted Answer · 2018-08-19 14:42:27Z

4

Apart from the lack of closing tags, the input you've shown looks like an XML variant. If that's the case, I'd suggest using XML tools instead of regex:

Select-Xml -Path path\to\file.xml -XPath '//Mapping[@ServerPath and @LocalPath]'|%{
    # grab the values of these
    $_.Node.ServerPath
    $_.Node.LocalPath
}

answered Aug 19, 2018 at 14:42

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Comments

Raj Sappidi · Accepted Answer · 2018-08-19 15:12:07Z

1

To extract those two paths:

$input_path = 'C:\inputpath.txt'
$output_file = 'C:\outputpath.txt'
$regex = 'ServerPath=[^\s]+|LocalPath=[^\s]+'
select-string -Path $input_path -Pattern $regex -AllMatches | % { $_.Matches } | % { $_.Value } > $output_file

edited Aug 19, 2018 at 15:12

answered Aug 19, 2018 at 14:31

Raj Sappidi

1568 bronze badges

1 Comment

Shayki Abramczyk Over a year ago

Thank you! it also works! but I prefer the XML solution.

Collectives™ on Stack Overflow

Extracting values from string in PowerShell (with Regex)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related