Replace multiple strings in multiple rows in html file

[sasaz12]

Hi All. I have html file and  need to find row that contains string !dataset1! (easy part) and replace that row + next row with data stored in variable @mydata. I tried various things but it didn’t work.
!dataset1! is the only constant value I set in this html to find specific table.

PowerShell

$mydata = @' some data some data new row '@

1 2 3 4

$mydata = @' some data some data new row '@

Table !dataset1! Data Table !dataset2! Data

• This topic was modified 8 months, 3 weeks ago by sasaz12.
• This topic was modified 8 months, 3 weeks ago by sasaz12.
• This topic was modified 8 months, 3 weeks ago by sasaz12.
• This topic was modified 8 months, 3 weeks ago by sasaz12.
• This topic was modified 8 months, 3 weeks ago by sasaz12. Reason: Had an issue with pasting html code

[Olaf Participant Topics: 10 Replies: 2481 Points: 6,543Rank: Community MVP]

To find a string in a text you could use Select-String. This would give you the line of text the string was found in. This you could use to replace it.

[sasaz12 Participant Topics: 2 Replies: 9 Points: 91Rank: Member]

Olaf wrote:

To find a string in a text you could use Select-String. This would give you the line of text the string was found in. This you could use to replace it.

Tried without success in this case. Which code you would use?

[Olaf Participant Topics: 10 Replies: 2481 Points: 6,543Rank: Community MVP]

PowerShell

Select-String -Path 'Complete Path To Your HTML File' -Pattern '!dataset1!' -SimpleMatch | Select-Object LineNumber

1	Select-String -Path 'Complete Path To Your HTML File' -Pattern '!dataset1!' -SimpleMatch | Select-Object LineNumber

You should always read the complete help including the examples for the cmdlets you’re about to use to learn how to use them. And it helps usually to play a little bit with it and to try this and to try that.

[sasaz12 Participant Topics: 2 Replies: 9 Points: 91Rank: Member]

Olaf wrote:

I have no issue with finding string with select-string but to replace row with !dataset1! + next row with my variable.

[Olaf Participant Topics: 10 Replies: 2481 Points: 6,543Rank: Community MVP]

When you know the line numbers you just skip these lines with Select-Object.

PowerShell

[INT]$MatchedLine = Select-String -Path 'Complete Path To Your HTML File' -Pattern '!dataset1!' -SimpleMatch | Select-Object -ExpandProperty LineNumber $HTMLContent = Get-Content -Path 'HTML File' $BeforeMatchedLine = $HTMLContent | Select-Object -First ($MatchedLine - 1) $AfterMatchedLine = $HTMLContent | Select-Object -Skip ($MatchedLine + 1) $BeforeMatchedLine, $mydata, $AfterMatchedLine | Out-File -FilePath 'HTML File'

1 2 3 4 5

[INT]$MatchedLine = Select-String -Path 'Complete Path To Your HTML File' -Pattern '!dataset1!' -SimpleMatch | Select-Object -ExpandProperty LineNumber $HTMLContent = Get-Content -Path 'HTML File' $BeforeMatchedLine = $HTMLContent | Select-Object -First ($MatchedLine - 1) $AfterMatchedLine = $HTMLContent | Select-Object -Skip ($MatchedLine + 1) $BeforeMatchedLine, $mydata, $AfterMatchedLine | Out-File -FilePath 'HTML File'

[sasaz12 Participant Topics: 2 Replies: 9 Points: 91Rank: Member]

Olaf wrote:

Very creative. You accomplished that without -replace command.

I haven’t seen/used LineNumber property before.

Thank you very much!

[Olaf Participant Topics: 10 Replies: 2481 Points: 6,543Rank: Community MVP]

sasaz12 wrote:

I haven’t seen/used LineNumber property before.

I recommended that in my first answer. :-/

[sasaz12 Participant Topics: 2 Replies: 9 Points: 91Rank: Member]

Olaf wrote:

sasaz12 wrote:

I haven’t seen/used LineNumber property before.

I recommended that in my first answer. :-/

Yeah, but your example didn’t makes sense to me at the moment 🙂

[Author]

Posts