I have already posted this yesterday under a different title so let me apologize for that in advance. The reason for reposting is that the problem has evolved a little and looking to get a solution tonight if possible.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I have approximately 10,000 or so lines of raw data in a txt file that I have to mine through and need a way to organize it into excel to make it manageable.
<o></o>
The raw data format is as follows:
<o></o>
AA/05-27-070-05W4/0 CVE FCCL C5 FISHER 5-27-70-5 0388819 A08C Savanna Drilling Corp. 447 28-Feb-2011 09:51:00 AM Bonnyville A2EZ Cenovus FCCL Ltd. 667.29 Re-entry <o></o>
I would need the data to be organized in this format in excel:<o></o>
A: AA/05-27-070-05W4/0 (this data column always structured the same and always ending in /0)<o></o>
B: CVE FCCL C5 FISHER 5-27-70-5 (this one will always end with a "-" and a number)<o></o>
C: 0388819 (always a 7 digit number)<o></o>
D:A08C (this is always 4 characters made up of numbers and letters)<o></o>
E:Savanna Drilling Corp. (always a company name)<o></o>
F:447 (this could either be a number or a combination of letters and numbers)<o></o>
G:28-Feb-2011 09:51:00 AM (always a date and time)<o></o>
H:Bonnyville (always a location)<o></o>
I:A2EZ (this is always 4 characters made up of numbers and letters)<o></o>
J:Cenovus FCCL Ltd. (always a company name)<o></o>
K:667.29 (this number is not on very many lines of data)<o></o>
L:Re-entry (this column is going to be one of 5 activities.<o></o>
Any help would be very much appreciated.<o></o>
Thank you.<o></o>
<o></o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o> I have approximately 10,000 or so lines of raw data in a txt file that I have to mine through and need a way to organize it into excel to make it manageable.
<o
></o> The raw data format is as follows:
<o
></o> AA/05-27-070-05W4/0 CVE FCCL C5 FISHER 5-27-70-5 0388819 A08C Savanna Drilling Corp. 447 28-Feb-2011 09:51:00 AM Bonnyville A2EZ Cenovus FCCL Ltd. 667.29 Re-entry <o
></o>I would need the data to be organized in this format in excel:<o
></o>A: AA/05-27-070-05W4/0 (this data column always structured the same and always ending in /0)<o
></o>B: CVE FCCL C5 FISHER 5-27-70-5 (this one will always end with a "-" and a number)<o
></o>C: 0388819 (always a 7 digit number)<o
></o>D:A08C (this is always 4 characters made up of numbers and letters)<o
></o>E:Savanna Drilling Corp. (always a company name)<o
></o>F:447 (this could either be a number or a combination of letters and numbers)<o
></o>G:28-Feb-2011 09:51:00 AM (always a date and time)<o
></o>H:Bonnyville (always a location)<o
></o>I:A2EZ (this is always 4 characters made up of numbers and letters)<o
></o>J:Cenovus FCCL Ltd. (always a company name)<o
></o>K:667.29 (this number is not on very many lines of data)<o
></o>L:Re-entry (this column is going to be one of 5 activities.<o
></o>Any help would be very much appreciated.<o
></o>Thank you.<o
></o><o
></o>
Last edited:
