Tidying up a text document

[simonh]

I have the following data which comes from exporting an Access
database. I'm not sure how the formatting will look (as there is no
preview post option), but basically I need to go from what you see
below to:

["Crimping Pliers", "Cerrti-lok Tyco 169400 Crimping Pliers",
"102956", "169406" ... etc]

or an array of hashes:

[{':Category => 'Crimping Pliers', escription => "Cerrti-lok Tyco
169400 Crimping Pliers", etc... ]

-----------------------------------------------------------------

Category: Crimping Pliers

Item Description Item
Ref Alt' Ref Location User

Cerrti-lok Tyco 169400 Crimping Pliers
102956 169 406 Unit 9
D.Brown (D) Overdue

Crimping Pliers Amp Blue Handles
102098 Unit 5 S
Roddy
Crimping Pliers Amp Ho 602.
102394 Unit 9
B.Minion Overdue

Crimping Pliers Certi Lok 169400
102295 Unit 9
B.Minion
Crimping Pliers Pressmaster Rs 297-2979
101959 P025505 Unit 5 S
Roddy

Crimping Pliers Right Angle
101960 921053 Unit 9
A.Minion 00158 Overdue
Crimping Pliers Variocrimp P170935
101953 P170935 Unit 9
B.Minion

Dmc Af8 Crimping Tool M22520/1-01
102951 027242 Unit 5
S.Roddy

Dmc Crimper
102474 Unit 5
S.Roddy
Knipex Crimpers 97 52 36
102454 Unit 5
S.Roddy

Knipex Crimpers 97 52 36
102453 Unit 5
S.Roddy Overdue
Tyco Certi-lok Crimping Pliers
102533 Unit 9
B.Minion

Category: Dial Gauges

Item Description Item
Ref Alt' Ref Location User

0-1" Linear Dti
103346 Unit 10
J.Simms
0-1" Mitutoyo Dial Indicator
103056 Unit 15
A.Carlile

0-1" Mitutoyo Dial Indicator
103100 Unit 9
A.Mills

0-20mm Mitutoyo Dti
103345 KLC125 Unit 9
G.MacDonald
Dial Indicator
101728 Unit 1
M.Bowker

Draper Expert Dial Indicator 0-25mm 0.01mm
103018 Unit 4
G.Childs Overdue
Dti
102448 Unit 8
A.Hepple Overdue

Dti 0-1" Linear
102574 Unit 10
J.Simms Overdue
Dti Linear 0-1"
102565 Unit 1
A.Hepple Overdue

Dti Mitutoyo
102085 FLR453 Unit 15
A.Carlile

 

[Ryan Davis]

I have the following data which comes from exporting an Access
database. I'm not sure how the formatting will look (as there is no
preview post option), but basically I need to go from what you see
below to:

["Crimping Pliers", "Cerrti-lok Tyco 169400 Crimping Pliers",
"102956", "169406" ... etc]

or an array of hashes:

[{':Category => 'Crimping Pliers', escription => "Cerrti-lok Tyco
169400 Crimping Pliers", etc... ]

hash = Hash[columns.zip(values)]

ri Hash::[]

and

ri Enumerable.zip