Slicemahn
12-18-2007, 06:28 AM
Hello Everyone,
I have been trying to arrange data in a way that can be updated to a database. To do so I would need to the data to be rearranged. I have over 32K rows in which the data is divided into three groups seperated by a blank line.
The data looks like the following
Wireless
Ottawa Montreal
Benjamin.Goody 123 0
George.Constanza 100 0
Jerry.Seinfeld 123 0
Cosmo.Kramer 0 123
Lloyd.Braun 0 100
Serenity.Now 0 130
.
.
.
VOIP
Ottawa Montreal
Elaine.Benace 0 112
David.Putty 0 123
Larry.David 0 100
Baboo.Bhatt 100 0
Jerry.Seinfeld 119 0
.
.
And there is another section similar. Using the first section, I want my output to be...
Benjamin.Goody 123 Ottawa Wireless
George.Constanza 100 Ottawa Wireless
Jerry.Seinfeld 123 Ottawa Wireless
Cosmo.Kramer 123 Montreal Wireless
Lloyd.Braun 100 Montreal Wireless
Serenity.Now 119 Montreal Wireless
I would appreciate any thoughts or suggestions.
I have been trying to arrange data in a way that can be updated to a database. To do so I would need to the data to be rearranged. I have over 32K rows in which the data is divided into three groups seperated by a blank line.
The data looks like the following
Wireless
Ottawa Montreal
Benjamin.Goody 123 0
George.Constanza 100 0
Jerry.Seinfeld 123 0
Cosmo.Kramer 0 123
Lloyd.Braun 0 100
Serenity.Now 0 130
.
.
.
VOIP
Ottawa Montreal
Elaine.Benace 0 112
David.Putty 0 123
Larry.David 0 100
Baboo.Bhatt 100 0
Jerry.Seinfeld 119 0
.
.
And there is another section similar. Using the first section, I want my output to be...
Benjamin.Goody 123 Ottawa Wireless
George.Constanza 100 Ottawa Wireless
Jerry.Seinfeld 123 Ottawa Wireless
Cosmo.Kramer 123 Montreal Wireless
Lloyd.Braun 100 Montreal Wireless
Serenity.Now 119 Montreal Wireless
I would appreciate any thoughts or suggestions.