Extracting specific data from a string with regex and Powershell
The quick and dirty:
$found = $string -match '.*spid="(\d+)".*'if ($found) { $spid = $matches[1]}where $string is your above mentioned string. This would match any string that has spid="somenumberhere", and make the number into a matched group, which you can extract using $matches[1].
Save that as, say $string.
Then do
$string -match 'spid="(\d+)"'If there is a match, the value you want will be in $matches[1]