数据导入类型来源
?
# to change this template, choose tools | templates
# and open the template in the editor.
?
#puts "hello world"
str = file.read('d:/csvtest.txt')
valuefile = file.new('d:/orig.txt','w')
$stdout = valuefile
str.gsub!(/"|\+|\n/,'')
str.sub!(/select|select/,'')
#puts str
index = str.index(' where ')
#puts str[0..index]
str[index..-1] =''
arry = str.split(' from ')
colvalue = arry[0]
orivalue =arry[1]
value = []
value_hash = hash.new
while /\,/ =~ colvalue
? sign_index = colvalue.index(',')
? if colvalue[0..sign_index].count('(') == colvalue[0..sign_index].count(')')
?
? ? value << colvalue[0...sign_index].gsub('|',',')
? ? value[-1].gsub!("<span style="white-space: pre;"></span>",'')
? ? value[-1].gsub!(" ",'')
? ? colvalue[0..sign_index] = ''
? else
? ? colvalue[sign_index] = '|'
? end
end
value << colvalue
puts value
puts "____" *20
valuefile.close
$stdout =stdout
puts "fgi"
#puts arry[0]
#puts 'sdf' ?if "avagd".count('4') == 'aa'.count('a')
arry = orivalue.split(',')
for i in arry
? arry = i.split
? if arry.length == 2
? ? value_hash[arry[0]] = arry[1]
? ? # puts arry[1]
? end
end
finish = []
for i in value
? value_hash.each{|key,valueo|
?
? ? if /#{valueo}./ =~ i
? ? ? index = i.index("#{ valueo}\.")
? ? ? #puts index
? ? ? if index == 0
? ? ? ? puts i
? ? ? ? i[index..index + 1] = key
? ? ? ? finish << i
? ? ? ? #value.delete(i)
? ? ? ? # next
? ? ? ? # break
?
# ? ? ?else /\(/ =~ i[index - 1...index]
# ? ? ? ?puts i
# ? ? ? ?i[index..index + 1] = key
# ? ? ? ?finish << i
# ? ? ? ?value.delete(i)
? ? ? end
?
? ? end
?
? ? # puts "#{key}=>#{value}"
? }
end
?
puts finish
#valuefile.close
#$stdout =stdout
##puts value_hash
?
def ishasoname hash,value,finish
? hash.each{ |key,hash_vl|
? ? hash_vl ?= hash_vl.to_s
? ? hash_vl << '.'
? ? if index = value.index(hash_vl)
? ? ? if index == 0 or /\w/ =~ value[index - 1 ...index]
? ? ? ? value[index..index+1] = key
? ? ? ? puts value
? ? ? ? finish << value
?
? ? ? ? reuturn
? ? ? end
? ? end
?
? }
? puts value
? finish << value
? puts hash
end
