How to insert newlines into strings when working with excel in ruby (Focus on Science, Morty!)

microsoft_excel_is_a_pile_of_shit_and_bill_gates_knows_it_da_doy.rb

POOR_MANS_LINE_BREAK = '__br__'

# How to insert newlines into strings when working with excel in ruby.
#
# NOTE: There are probably better ways of doing this, but this works for me.    -uly, oct 2017
#
# See https://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell
# GOTCHA: Careful to guard against blank strings; breaks excel and will result in a "repair".
def insert_newlines_into_excel_value_if_any(s)
  s = "=SUBSTITUTE(\"#{ s.gsub(/\n/, POOR_MANS_LINE_BREAK) }\", \"#{ POOR_MANS_LINE_BREAK }\", CHAR(13))" if s =~ /\n/
  s
end