csv_parser.rb in eco-helpers-1.5.12

- old
+ new

@@ -3,12 +3,11 @@
 
   def parser(data, deps)
     Eco::CSV.parse(data, headers: true, skip_blanks: true).each_with_object([]) do |row, arr_hash|
       row_hash = row.headers.uniq.each_with_object({}) do |attr, hash|
         next if attr.to_s.strip.empty?
-        value            = row[attr]
-        hash[attr.strip] = value.to_s.empty?? nil : value
+        hash[attr.strip] = parse_string(row[attr])
       end
       arr_hash.push(row_hash)
     end
   end
 
@@ -19,8 +18,22 @@
       arr_rows = array_hash.map do |csv_row|
         CSV::Row.new(header, csv_row.values_at(*header))
       end
     end
     CSV::Table.new(arr_rows).to_csv
+  end
+
+  private
+
+  def parse_string(value)
+    return nil if value.to_s.empty?
+    return nil if null?(value)
+    value
+  end
+
+  def null?(value)
+    return true if !value
+    str = value.strip.upcase
+    ["NULL"].any? {|token| str == token}
   end
 
 end