Remove blank rows from CSV file

Question

I have a CSV file that contains blank rows like this:

row A

row B
row C


row D

How should I proceed to remove those blank rows to have:

row A
row B     
row C  
row D

I found many topics on this subject for other languages but none in Ruby.

stackoverflow.com/questions/7339292/…

Gavriel
– Gavriel

2016-01-18 11:56:19 +00:00
Commented Jan 18, 2016 at 11:56 — Gavriel
– Gavriel, Commented Jan 18, 2016 at 11:56

steenslag · Accepted Answer · 2018-11-11 01:03:53Z

4

You don't have to delete the blank lines, just skip them:

require "csv" 

CSV.foreach("path/to/file.csv", skip_blanks: true) do |row|
  # handle row, it won't be blank
end

answered Nov 11, 2018 at 1:03

steenslag

80.2k16 gold badges144 silver badges174 bronze badges

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

Comments

Kristján · Accepted Answer · 2016-01-19 16:00:47Z

3

Three simple steps:

data = File.read('data.csv')                       # Read the file
cleaned = data.gsub(/^$\n/, '')                    # Remove blank lines, from [1]
File.open('out.csv', 'w') { |f| f.write(cleaned) } # Write the cleaned data

[1] Remove empty lines from string

answered Jan 19, 2016 at 16:00

Kristján

19k5 gold badges55 silver badges65 bronze badges

Collectives™ on Stack Overflow

Remove blank rows from CSV file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related