Hello all,

 I'm totally new to powershell and have the problem detailed below. I've tried Googling round for the answer to this problem, and am not sure if the answer is so simple it simply doesn't rank, or this is in fact more difficult than it looks.\s

 What I'm trying to do is strip the values from a dynamic XML file, so I can then dedupe the values and output a tailor made schema to upload to SQL server. Obviously the structure and dynamic nature of the file make using something saner impossible without the schema. I have posted the code and a sample of the XML below, but what I would like to achieve is replacing everything between and including the double quotation marks. To achieve this I was using a find and replace, where the find looked like this: "=`"*`"\s" and replace with this: =

The hope being to turn something similar to this:






Into this:






Except it doesn't. Below is the code, any help would be much appreciated.
Thanks,

James

$filename = "XMLSchemaTestData.xml" $match = "=`"*`"\s" "'"+$match+"'" # : encoding="utf-8"? : <?xml version="1.0" encoding="utf-8"?> $replacement = "=" #Print $replacement $content = Get-Content $filename #$content $content = $content -creplace $match,$replacement #$content $content | Set-Content $filename

Your XML got parsed, add it as an attachment instead.

Hi All

GWHowarth88 - many thanks for the pointer.

Finally I located the problem in the regex, it should have looked more like this:

(Get-Content XMLSchemaTestData.xml) |
Foreach-Object {$_ -replace '("[^"\r\n]*")', "="} |
Set-Content XMLSchemaTestData.xml

Now it works,

Regards,

James