Pastable version of Parsing non-delimited text

<pre class='prettyprint' language='ruby'>def writefile(file, *linedata)
	linedata.each do |line| 	
		file &lt;&lt; line.join(&quot;,&quot;) + &quot;\n&quot;
	end
end

def readfile(file, outputfile)
	out = File.new(outputfile, &quot;w+&quot;)
	info = []
	wline = ['year', 'week', 'day', 'customerid', 'customer', 'subcustid', 'subcust', 'prodid', 'prod', 'qty']
	IO.foreach(file){|line|
		if line =~ /Customer/
			wline[3] = line.split(&quot;:&quot;)[1].scan(/\d+/)
			wline[4] = line.split(&quot;:&quot;)[1].scan(/[a-zA-Z]+/).join(&quot; &quot;)
		elsif line =~ /Sub-cust/
			wline[5] = line.split(&quot;:&quot;)[1].scan(/\d+/)
			wline[6] = line.split(&quot;:&quot;)[1].scan(/[a-zA-Z]+/).join(&quot; &quot;)
		elsif line =~ /Year/
			wline[0] = line.scan(/\d+/)[0]
		elsif line =~ /Week/
			wline[1] = line.scan(/\d+/)[0]
		elsif line.strip! =~ /\A\d/
			wline[7] = line.scan(/\A\d+/)
			temp = line.scan(/[A-Za-z]+/)
			wline[2] = temp.pop #later used for delivery day
			wline[8] = temp.join(&quot; &quot;)
			wline[9] = line.scan(/\d+/)[line.scan(/\d+/).length-13].to_i
			wline[9] &gt; 0 ? writefile(out, wline) : wline
		elsif 	line =~ /\AMON/ || line =~ /\ATUE/ || line =~ /\AWED/ || 
				line =~ /\ATHU/ || line =~ /\AFRI/ || line =~ /\ASAT/ || 
				line =~ /\ASUN/
			wline[2] = line.scan(/[A-Za-z]+/)
			wline[9] = line.scan(/\d+/)[line.scan(/\d+/).length-13].to_i
			wline[9] &gt; 0 ? writefile(out, wline) : wline
		end
		
	}
	out.close
end
readfile('source_exmaple', 'output.txt')

=begin

Example of source data

Customer  :     97  CUSTOMER A                  
Year       :   2008
Week      : 39 ..  39
Sub-cust  :    999  DEPARTMENT A

------------------------------------------------------------------------------------
ARTIKEL                          Dag     V E R B R U I K                 
nr.    omschrijving                       39      0      0      0      0      0      0      0      0      0  Totaal Gemiddeld Norm       
------------------------------------------------------------------------------------

1234  PRODUCT A Beeee      MON    150    0  0  0  0  0  0  0  0  0  150  150    0
                              TUE     50    0  0  0  0  0  0  0  0  0   50   50    0

P E R I O D E   O V E R Z I C H T   A B S O L U T E   L E V E R I N G   P E R   D A G 
                       =====================================================================================
=end</pre>
<a href="http://www.refactormycode.com/codes/519-parsing-non-delimited-text" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Parsing non-delimited text