String substitution within ruby array

Question

I have the following code, within which I want to change certain values to csv friendly, e.g., 'nil' to ''. I need to know how to make these changes. Thank you.

  def daily_door_schedule
    @tickets = Ticket.where(active: true).
      pluck(
        :door_manufacturer,
        :job_number, 
        :door_style, 
        :door_allocation_date,
        :date_doors_received_in_aub, 
        :door_delivery_due_date,
        :notes
      )

    respond_to do |format|
      format.html
      format.csv { render text: @tickets.to_csv }
    end
  end

to_csv can handle nil values, it results in an empty field — Stefan
– Stefan, Commented Sep 8, 2015 at 19:36
What is the specific problem? The CSV class doesn't create strings containing the word 'nil'. — Mark Thomas
– Mark Thomas, Commented Sep 8, 2015 at 19:42
Ruby doesn't have methods where or pluck. If they're not defined in Ticket, you need at least one more tag. — Cary Swoveland
– Cary Swoveland, Commented Sep 8, 2015 at 19:59

Anthony · Accepted Answer · 2015-09-08 20:43:50Z

3

This should do it:

@tickets = Ticket.where(active: true).
  pluck(
    :door_manufacturer,
    :job_number, 
    :door_style, 
    :door_allocation_date,
    :date_doors_received_in_aub, 
    :door_delivery_due_date,
    :notes
  ).map { |ticket| ticket.map(&:to_s) }

edited Sep 8, 2015 at 20:43

answered Sep 8, 2015 at 19:00

Anthony

16.1k4 gold badges43 silver badges69 bronze badges

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

2 Comments

Cary Swoveland Over a year ago

Anthony, this is what happens when you don't use your reading glasses.I think you want el ||= ''. If el is a string or nil, you could also write ticket.map(&:to_s), but I guess you want strings anyway. (I say this without knowing what pluck does.)

Anthony Over a year ago

I just went to the optometrist for the first time in my life 2 weeks ago... your comment couldn't be more appropriate. As always, thank you for the suggestion - it's perfect.

Collectives™ on Stack Overflow

String substitution within ruby array

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