0

I got a csv file that contains some empty rows between the headers and other rows. For example:

Headers-----------------------------
Empty Rows------------A-------------
Empty Rows------------B-------------
Empty Rows------------C-------------
Data--------------------------------
Data--------------------------------

How to remove those empty rows (A,B and C) from CSV file using powershell?

I thought this would be an easy Google search but I can only find something like "remove lines from text file".

Improve this question
3
  • 1
    Which doesn't apply for what reason? A CSV file is a text file. As such solutions from e.g. this question are solutions to this one. Commented Feb 6, 2017 at 13:37
  • @Seth I did not realise that they are the esame thing, I'll try that. Commented Feb 6, 2017 at 13:41
  • You can open it in your text editor of choice and can read all the information within it without (major) problems. So it's a text file in comparison to a binary file which would look really wicked. Though it might be hard to interpret whatever is in that text file. Commented Feb 6, 2017 at 13:44
Related questions
2913
Determine installed PowerShell version
3005
PowerShell says "execution of scripts is disabled on this system."
2450
Concatenate text from multiple rows into a single text string
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.