Converting string to csv

Question

I have a piece of code in Ruby which essentially adds multiple lines into a csv through the use of csv_out << listX I have both a header that I supply in the **options and regular data. And I am having a problem when I try to view the CSV, mainly that all the values are in one row and it looks to me that any software fails to recognize '\n' as a line separator.

Input example:

Make, Year, Mileage\n,Ford,2019,10000\nAudi, 2000, 100000

Output dimensions:

8x1 table

Desired dimensions:

3x3 table

Any idea of how to go around that? Either by replacing '\n' with something or using something else than csv.generate

csv = CSV.generate(encoding: 'UTF=8') do |csv_out|
   csv_out << headers
   data.each do |row|
      csv_out << row.values
   end

Please post your actual code rather than just describing it. Right now I am unclear on the issue you are experiencing because the CSV docs clearly states that the column separator defaults to comma and the row separator defaults to :auto (which includes "\r\n", "\n", and "\r") — engineersmnky
– engineersmnky, Commented Nov 3, 2021 at 17:06
"any software fails" – which software is that in particular? CSV isn't fully standardized, you might have to adjust col_sep or row_sep. (or set your software's import options) — Stefan
– Stefan, Commented Nov 3, 2021 at 17:14
At the moment when I try to copy csv variable (which is a long string) and save it as txt file, software like Excel, Numbers and Google Sheets displays it as one row in 8x1 dimensions — Arthur Edelman
– Arthur Edelman, Commented Nov 3, 2021 at 17:15
@ArthurEdelman maybe you copy those \n literally? Try File.write("cars.csv", csv) to eliminate copy-paste errors. — Stefan
– Stefan, Commented Nov 3, 2021 at 17:51

user1934428 · Accepted Answer · 2021-11-04 07:54:51Z

1

The problem seems to be the data.each part. Assuming that data holds the string you have posted, this loop is executed only once, and the string is written into a single row.

You have to loop over the indivdual pieces of data, for instance with

data.split("\n").each

answered Nov 4, 2021 at 7:54

user1934428

22.8k9 gold badges57 silver badges108 bronze badges

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

2 Comments

Arthur Edelman Over a year ago

Data object in this case is an array of Hashes

user1934428 Over a year ago

Hence, row is a Hash. But << assumes the argument to be either of type String or CSV::row. What do you expect when you pass a Hash? See here.

Collectives™ on Stack Overflow

Converting string to csv

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related