This code reads in a text file with comma separated values. Problem is,
some values are missing and it causing other values to ride up the list.
I want to replace those values with string 'no value' then adjust there
others if the next value is not listed on the second iteration of the
array. I am new to learning programming.
patientrecords.txt
1,PersonID,PersonID
2,ID,ID
3,LastName,Social Security #<-insert 'no value'
4,Social Security, Address #<-change array[2] Social Security
5,Address,UniqueID #<-change array[2] to Address
6,UniqueID,Potassium #<-change array[2] to UniqueID
···
**************************************************
File.open('patientrecords.txt', 'r') do |temp|
array = []
temp.each_line do |line|
array = line.chomp.split(",",0)
nextVal = array[0].to_i + 1
line.each_line do |n1|
if array[1] != array[2] then
if array[0] != nextVal then
array[2] = "no value"
end
#array[2] = array[1] #populates the array[2]
end
end
puts array[0]+","+array[1]+","+array[2]
end
end
Attachments:
http://www.ruby-forum.com/attachment/3148/patientrecords.txt
--
Posted via http://www.ruby-forum.com/.