Delete empty rows in multiple csv files by using Powershell [duplicate]

Question

To delete empty rows in multiple CSV files by using Powershell. This is the code I am trying to use for each loop. But it is writing empty files. The resulting file should open in Excel and Notepad++ in proper format.

Get-ChildItem $paramDest -Filter *Test*.csv | ForEach-Object {
$content = Get-Content $_.FullName | Where { $_.Replace("","","").trim() -ne "" }
Out-File -InputObject $content -FilePath $_.FullName
}

I have some other set of files, the code should work for both these kinds of files. I am okay to have 2 separate codes for these 2 separate files.

Here is another file sample format

Does this answer your question? delete empty rows at end of the csv file using Powershell — iRon
– iRon, Commented Jul 30, 2021 at 6:35

Bharat · Accepted Answer · 2021-07-30 06:13:24Z

1

Try with this

Input

Command

Import-Csv -Path "C:\sample.csv" | Where-Object { $_.PSObject.Properties.Value -ne '' } | Export-Csv -Path "C:\Sample_clean.csv" -NoTypeInformation

Output*

Edit: To update Multiple files, thanks to @Santiago Squarzon

Get-ChildItem $paramDest -Filter *Test*.csv | 
Foreach-Object { 

# get the content of file
$content = Get-Content $_.FullName 

# replace all "," with empty string and exclude those lines and save the output to original file
$content  | where { $_.Replace('","','').trim('"') -ne '' } | Set-Content $_.FullName 
}

edited Jul 30, 2021 at 6:13

answered Jul 30, 2021 at 4:19

Bharat

1,1958 silver badges14 bronze badges

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

3 Comments

DAR Over a year ago

I have multiple files, tried the below code, not working as expected $paramDest = "C:\Test\" Get-ChildItem $paramDest -Filter *.csv | ForEach-Object { Import-Csv -Path $_.FullName | Where-Object { $_.PSObject.Properties.Value -ne '' } | Export-Csv -Path $_.FullName -NoTypeInformation }

Bharat Over a year ago

Do you want to run this line for many file? this sample is for a file and it works perfectly

Bharat Over a year ago

@user10260125 updated the solution for multiple files

Collectives™ on Stack Overflow

Delete empty rows in multiple csv files by using Powershell [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related