Importing Text into Excel Files Automaticly!

[8Bits]

Every day I run a series of batch files to get folder sizes and server space free and used. I then manually copy the info from the .txt files into an excel sheet where I can easily create graphs showing various trends.

The data comes in .txt files layed out like so:

Size (mb) Files Directory
98.27 95 SUB-TOTAL: N:\000000plot
87.90 115 SUB-TOTAL: N:\00001_job1
163.55 299 SUB-TOTAL: N:\00002_job_2
138.28 240 SUB-TOTAL: N:\00033_job
etc..........................................

What I need is get the first figure (eg 98.27) and what comes after the n:\ (eg 000000plot) to import automatically into new rows on a new sheet of an already created excel file.

I know it's all a bit vaugue, I don't know if it can be done ? MAcros ? or anything else anyone can suggest.

All tek-tips greatly accepted.

Cheers
Gerry R

 

[Lrnmore]

You might try opening the file in wordpad
replacing the SUB-TOTAL: N:\ with " "
Save as plain .txt format....

Then you have a space delimited file you
can open in excel.

Hope it helps!
Mark V.