Skip to content

Instantly share code, notes, and snippets.

@geeky-sh
Created March 15, 2014 08:14
Show Gist options
  • Save geeky-sh/9563336 to your computer and use it in GitHub Desktop.
Save geeky-sh/9563336 to your computer and use it in GitHub Desktop.
ruby code for validating rows in a csv file
valid = []
invalid = []
File.open('file.txt') do |f|
f.each_line do |l|
user_id, item_id, price_id = l.split(',').map {|x| x.strip.to_i}
if user_id.to_s.size == 5 && item_id.to_s.size >= 1 && item_id.to_s.size <= 3 && price_id > 0
valid << l
else
invalid << l
end
end
end
File.open('valid.txt', 'w') {|f| f.puts(valid)}
File.open('invalid.txt', 'w') {|f| f.puts(invalid)}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment