Powershell replace value in array error

Question

I have been trying to replace values within an array and I am currently trying to sanitize some of the values. I am trying to remove the table tags through the use of an array, or perhaps there is a better way to do the regex? Any help would be appreciated! Thanks.

$array = [regex]::matches($lines, "<td>(.*?)</td>")

    for($x = 0; $x -le $max; $x++){
        $array[$x] = $array[$x].value -replace "<td>", ""
    }

Unfortunately, I continuously get the error below:

    [ : Unable to index into an object of type System.Text.RegularExpressions.MatchCollection.

mjolinor · Accepted Answer · 2013-02-11 18:26:06Z

3

$array = $lines -replace '<td>(.*?)</td>','$1'

answered Feb 11, 2013 at 18:26

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

Comments

KevinD · Accepted Answer · 2013-02-11 21:57:19Z

1

$array = $lines | ? {$_ -match "<td>(.*?)</td>"} | % {$_.Replace("<td>", "").Replace("</td>", "") }

If you only want to replace , and not , just omit the second Replace.

Better yet, if you want to replace both:

$array = $lines | ? {$_ -match "<td>(.*?)</td>"} | % {$_ -replace "</?td>", ""}

In answer to your comments, this might work better:

$array = [regex]::matches($lines, "<td>(.*?)</td>") | Select -exp Value | % {$_ -replace "<td>(.*?)</td>", '$1'}

I suspect there is a better way to do this, as applying the regular expression twice seems inefficient, but I think it should work.

Okay, I think I've got it. Try this:

$array = [regex]::matches($lines, "<td>(.*?)</td>") | % {$_.Result('$1')}

edited Feb 11, 2013 at 21:57

answered Feb 11, 2013 at 17:50

KevinD

3,1732 gold badges24 silver badges26 bronze badges

6 Comments

rawrPowershell Over a year ago

hmm, this definitely replaces contents which is great, but it doesn't place it into an array. I believe it places the contents into a very long string. I need the array to do a .getCount and then run through another loop to build a csv. I have tried doing $array = @() and running the code snippet, but can't seem to figure it out. Any suggestions? Thanks!

KevinD Over a year ago

Assuming that $lines is an array, $array is one as well. To test, I populated $lines with: $lines = Get-Content test.html

rawrPowershell Over a year ago

$lines is currently one long string and I break each <td> line into one row within the array using the [regex] command

KevinD Over a year ago

There is probably a better way to do this, but I came up with this, combining your first RegEx query, with the '$1' trick suggested by mjolinor: $array = [regex]::matches($lines, "<td>(.*?)</td>") | Select -exp Value | % {$_ -replace "<td>(.*?)</td>", '$1'}

KevinD Over a year ago

I just updated my answer with what I think is a much better solution.

|

Collectives™ on Stack Overflow

Powershell replace value in array error

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related