Write value to CSV Column with RUBY

Question

I have columns with headers as such:

First,Last,ID,Type

The first row of data looks like this:

Jon,Smith,123,,

There is no value under the fourth column Type.

I have a script that parses each column into an array and does different actions based on the first three criteria, First,Last,ID.

I need to write to the CSV file. The logic would look like this:

If First == Jon, Last == Smith, and ID == 123, write "Success" to Type

I have the following script:

   CSV.open("Content_File.csv", "wb") do |csv|
     csv << ["row", "of", "CSV", "data"]
     csv << ["another", "row"]

but all it does is write content to a CSV file row by row. I need to write to a specific row and a specific column.

Any thoughts?

Community · Accepted Answer · 2017-05-23 10:32:15Z

1

Short answer is you cannot (that is, you still need to iterate through the whole file and write out another one). For The longer version, please see here.

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Aug 23, 2013 at 1:31

Benjamin Tan Wei Hao

9,6723 gold badges34 silver badges57 bronze badges

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

1 Comment

Luigi Over a year ago

Gotcha. I suppose I could pull all the existing CSV values and just overwrite the file, passing in my new value alongside all the old values. I'll probably just write a new CSV file and do a VLOOKUP though. Thanks for the guidance.

Collectives™ on Stack Overflow

Write value to CSV Column with RUBY

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related