eristoddle
3/29/2016 - 4:45 PM

Powershell script to parse xml in csv and expand it

Powershell script to parse xml in csv and expand it

$records = Import-Csv BadResults.csv

foreach($record in $records){
	$xml = new-object System.Xml.XmlDocument
	$fraudScore = $record.FraudScoreDetails
	$xml.LoadXml($fraudScore)
	foreach ($i in $xml.response.rule){
		#Write-Output $i.criteriaEvaluated
		#Write-Output $i.evaluationResult
		$record | Add-Member NoteProperty $i.criteriaEvaluated $i.evaluationResult
	}
}

$records | Export-Csv -Path ExpandedBadResults.csv -NoTypeInformation