PDA

View Full Version : [SOLVED] Place data of logfile in a sheet



jphermans
01-17-2005, 06:25 AM
I've got an logfile with a lot of information that looks like this:

17.01.2005 08:59:07
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 01 Program: P2.X_Alu Bolt T: 140.8 Bolt A: 66 OK Errors:
Bolt 02 Program: P2.X_Alu Bolt T: 142.0 Bolt A: 73 OK Errors:
Bolt 03 Program: P2.X_Alu Bolt T: 143.5 Bolt A: 70 OK Errors:
Bolt 04 Program: P2.X_Alu Bolt T: 143.6 Bolt A: 68 OK Errors:
Bolt 05 Program: P2.X_Alu Bolt T: 141.1 Bolt A: 69 OK Errors:


17.01.2005 08:59:33
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 06 Program: P2.X_Alu Bolt T: 140.4 Bolt A: 64 OK Errors:
Bolt 07 Program: P2.X_Alu Bolt T: 140.1 Bolt A: 68 OK Errors:
Bolt 08 Program: P2.X_Alu Bolt T: 142.7 Bolt A: 60 OK Errors:
Bolt 09 Program: P2.X_Alu Bolt T: 140.3 Bolt A: 63 OK Errors:
Bolt 10 Program: P2.X_Alu Bolt T: 142.3 Bolt A: 66 OK Errors:

Now i want every thing in an excel sheet in colums like this:
Bolt,program, Bolt T: , Bolt A: ,...

But the logfile is 10mb and is to much work to do it manually.
Anybody an idea how to solve it with vba ?

Jacob Hilderbrand
01-17-2005, 06:41 AM
First copy the data into Excel. Then use (Data | Text To Columns) on the data to modify it.

In the Text to Columns wizard:
1) Choose Delimited
2) Check the box for Space
3) Select General and for the destination just put the cell address for where you want the data to start.