delete empty rows at end of the csv file using Powershell

Question

I need to delete the empty rows at end of the CSV file using Powershell. I tried the below code This code only working to remove the line 7 and 8 in the below sample file image. But I need to delete rows 3,4,5,6,7 and 8. Only row 2 has data. Any suggestion would be appreciated. thank you.

$content = [System.IO.File]::ReadAllText("PPC.csv")
$content = $content.Trim()
[System.IO.File]::WriteAllText("PPC_1.csv", $content)

Answer 1

There were two sources that helped me out, Powershell - remove blank/empty rows from CSV file and this StackOverflow question to remove empty lines from text file.

Get-Content "test.csv" | Where { $_.Replace(",","").trim() -ne "" } | Out-File trimmed.csv

To be fair, this line assumes that you're always going to have commas as your separator and that a line consisting only of commas and whitespace would be considered empty. I hope this helps! I recommend looking at those links.