I have more that 250 txt files generated from MesNews newsreader. Simplified file structure is herebelow:
---------------------
Group : aLIsveris
Computing time : 00:00:00
Statistics : from 01.01.2006 to 18.10.2006
***** Users with most messages *****
113 : Bugrahan
94 : [|| | ||| || |||] ³¹
82 : bb
***** Users with most started threads *****
44 : paragona
25 : Bugrahan
21 : m@cHka
***** Days with most messages *****
66 : 03.10.2006
61 : 13.02.2006
59 : 12.02.2006
***** Subjects with most answers *****
46 : Benzin Zamlarini Protesto Ediyoruz..
40 : D&R Rezilligi...
32 : MEB kapsamindaki Toshiba
***** Summary results *****
Total found messages : 6144 for 291 days
New threads : 1870
Total replies : 4274
Total modified threads : 1880
Total size : 10392217 bytes (10.148,65 KB)
Total lines : 168762 lines
Total users : 1292
Average number of messages by user : 4,76
Average size of messages by user : 8.043,51 bytes (7,85 KB))
Average number of lines by user : 130,62
------------------------
I need copy and save specific rows between the cells which are determined by contents of them.
Such as, I want to get rows between the cells which contains "Users with most started threads" and "Days with most messages" and save the new file into a specific location (i.e. "D:\anet\users") as txt file, without any changes to the file structure, for the all text files.
Original text files is located at the "D:\anet\data"
Thanking you already now.
p.s. I will do this four times more for different rows, but I believe that I can modify the macro :wink:
---------------------
Group : aLIsveris
Computing time : 00:00:00
Statistics : from 01.01.2006 to 18.10.2006
***** Users with most messages *****
113 : Bugrahan
94 : [|| | ||| || |||] ³¹
82 : bb
***** Users with most started threads *****
44 : paragona
25 : Bugrahan
21 : m@cHka
***** Days with most messages *****
66 : 03.10.2006
61 : 13.02.2006
59 : 12.02.2006
***** Subjects with most answers *****
46 : Benzin Zamlarini Protesto Ediyoruz..
40 : D&R Rezilligi...
32 : MEB kapsamindaki Toshiba
***** Summary results *****
Total found messages : 6144 for 291 days
New threads : 1870
Total replies : 4274
Total modified threads : 1880
Total size : 10392217 bytes (10.148,65 KB)
Total lines : 168762 lines
Total users : 1292
Average number of messages by user : 4,76
Average size of messages by user : 8.043,51 bytes (7,85 KB))
Average number of lines by user : 130,62
------------------------
I need copy and save specific rows between the cells which are determined by contents of them.
Such as, I want to get rows between the cells which contains "Users with most started threads" and "Days with most messages" and save the new file into a specific location (i.e. "D:\anet\users") as txt file, without any changes to the file structure, for the all text files.
Original text files is located at the "D:\anet\data"
Thanking you already now.
p.s. I will do this four times more for different rows, but I believe that I can modify the macro :wink: