Remove a line from a CSV powershell

Question

I currently have the following csv

These, Are, Several, Columns
-----, ---, -------, -------
"And", "here", "is", "data"
"And", "some", "more", "data"

While I wish I could simply change the process that creates the csv to remove the line of dashes that isn't possible.

The line of dashes is always the 2nd line, can I use powershell to remove the 2nd line of data?

Bonus question, I'm looking to add at the bottom a blank line, followed by a paragraph of text. I'm guessing I would be able to use the add-content cmdlet, but I'm not entirely sure how.

user189198 · Accepted Answer · 2012-07-09 21:50:48Z

1

This command should work:

gc file.txt | ? { $_ -notlike '*----*' } | sc file2.txt

It essentially performs the following tasks:

Retrieves the content of file.txt
Filters (using Where-Object) content for lines not like ----
Writes the remaining content to file2.txt

answered Jul 9, 2012 at 21:50

user189198

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

4 Comments

mhopkins321 Over a year ago

thanks for the edit. I was just about to go look up what each section did. Any chance you could help with that adding a paragraph into the csv?

user189198 Over a year ago

Yeah, just like you said: Add-Content -Path File2.txt "BACKTICKnParagraph of text with a new lineBACKTICKngoes here just like this." Replace "BACKTICK" with an actual backtick. The BACKTICKn represents a new line.

mhopkins321 Over a year ago

am I able to save back into file.txt?

user189198 Over a year ago

Remove-Item File.txt; Move-Item File2.txt File.txt;

Collectives™ on Stack Overflow

Remove a line from a CSV powershell

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related