Create and append to CSV with ruby

Question

So I recently had to change to OSX from Ubuntu for work and I'm having some compatibility issue with my Ruby code. I'm trying to append to a CSV and if it doesn't exist, one should be created. I've used this code in Ubuntu and it worked just fine, I have no idea what the problem is.

CSV.open("~/Documents/Endeca/file.csv","a") do |csv|
    csv << [Text,Date,Name,id]
end

When I run it now, I get an error that says "No such file or directory." I'm using ruby 2.0.0 with rvm

Do you have all directories in the path in place? I mean, does ~/Documents/Endeca/ exist? — Manoj Awasthi
– Manoj Awasthi, Commented Aug 25, 2013 at 16:43

falsetru · Accepted Answer · 2013-08-25 16:46:42Z

5

~ is interpreted ~ literally. If you want home directory, you should expand it using File.expand_path.

File.expand_path('~/Documents/Endeca/file.csv')
# => "/home/falsetru/Documents/Endeca/file.csv"

answered Aug 25, 2013 at 16:46

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

1 Comment

nickg Over a year ago

Thanks! I actually just happened upon this myself, I'll have to keep that in mind in the future.

Collectives™ on Stack Overflow

Create and append to CSV with ruby

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related