Filling Excel Cells from text file...

[Veronic]

Hello All,

I have red many of Forum seeking for VBA solution for my issue, I found a couple of good one but non of them was completely useful for me... I am not professional programmer, so pls help me..

I have a 260.000-line-long logfile and my boss tasked me to pick up some information through the txt and fill an Excel table. I tried several option but only able to read the first block.

I prepared the two file to see what I need.
EXCEL TXT

 

[Veronic]

Links are broken...
It may help:


Scan Statistics : 28-Jul-2015 05:45:28 - Scan number = 18280 - Ver: 02.03

Fun Name Status Mode N1 N2 N3 N4 N5 In Out
A = Rcc Reg Op 251 145 1 1 752 254
B = Regime Op 175 0 0
C = Regime Op
D = Regime Op
E = Not Con Op
F = Not Con Op 0 0 0 0 0 0 0
G = Regime Op 111 31 145 1 3
H= Regime Op 21 31 145 1 3
I = Regime Op 21 31 145 1 3
J = Regime Op 21 31 145 1 3
K = Rcc Reg Op 0
L = Rcc Reg Op 3

VDR A = Rcc Reg Op Mti Map Transf : Wait
VDR B = Rcc Reg Op Op mode status : Idle
VDR C = Rcc Reg Op Current Slot = 0 - Request Chn = ABCD TC ACC
VDR D = Rcc Reg Op SECT RM W/P H/L Op-Modes FMS FAS MTI AMTI THR
SH A 5= Rcc Reg Op 01 00 p h 02=Anaprop D - man man man
SH B 4= Rcc Reg Op
SH C 4= Rcc Reg Op
SH D 3= Rcc Reg Op





Scan Statistics : 28-Jul-2015 05:45:40 - Scan number = 18281 - Ver: 02.03

Fun Name Status Mode N1 N2 N3 N4 N5 In Out
A = Rcc Reg Op 252 146 1 1 753 255
B = Regime Op 176 0 0
C = Regime Op
D = Regime Op
E = Not Con Op
F = Not Con Op 0 0 0 0 0 0 0
G = Regime Op 112 31 146 1 3
H= Regime Op 51 61 155 1 3
I = Regime Op 51 61 155 1 3
J = Regime Op 51 61 155 1 3
K = Rcc Reg Op 0
L = Rcc Reg Op 3

VDR A = Rcc Reg Op Mti Map Transf : Wait
VDR B = Rcc Reg Op Op mode status : Idle
VDR C = Rcc Reg Op Current Slot = 0 - Request Chn = ABCD TC ACC
VDR D = Rcc Reg Op SECT RM W/P H/L Op-Modes FMS FAS MTI AMTI THR
SH A 5= Rcc Reg Op 01 00 p h 02=Anaprop D - man man man
SH B 4= Rcc Reg Op
SH C 4= Rcc Reg Op
SH D 3= Rcc Reg Op



Clutter extraction activated during scan 18281



Scan Statistics : 28-Jul-2015 05:45:52 - Scan number = 18282 - Ver: 02.03

Fun Name Status Mode N1 N2 N3 N4 N5 In Out
A = Rcc Reg Op 255 125 1 1 712 254
B = Regime Op 175 0 0
C = Regime Op
D = Regime Op
E = Not Con Op
F = Not Con Op 0 0 0 0 0 0 0
G = Regime Op 151 31 145 1 3
H= Regime Op 21 31 145 1 3
I = Regime Op 21 61 145 1 3
J = Regime Op 21 31 145 1 3
K = Rcc Reg Op 0
L = Rcc Reg Op 3

VDR A = Rcc Reg Op Mti Map Transf : Wait
VDR B = Rcc Reg Op Op mode status : Idle
VDR C = Rcc Reg Op Current Slot = 0 - Request Chn = ABCD TC ACC
VDR D = Rcc Reg Op SECT RM W/P H/L Op-Modes FMS FAS MTI AMTI THR
SH A 5= Rcc Reg Op 01 00 p h 02=Anaprop D - man man man
SH B 4= Rcc Reg Op
SH C 4= Rcc Reg Op
SH D 3= Rcc Reg Op


Excel table What I need:
[TABLE="width: 640"]
<tbody>[TR]
[TD="width: 64, align: center"]Scan Time[/TD]
[TD="width: 64, align: center"]A/N1[/TD]
[TD="width: 64, align: center"]B/N2[/TD]
[TD="width: 64, align: center"]A/N3[/TD]
[TD="width: 64, align: center"]G/N1[/TD]
[TD="width: 64, align: center"]G/N2[/TD]
[TD="width: 64, align: center"]G/N3[/TD]
[TD="width: 64, align: center"]H/N1[/TD]
[TD="width: 64, align: center"]H/N2[/TD]
[TD="width: 64, align: center"]H/N3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]5:45:28[/TD]
[TD="align: center"]251[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]145[/TD]
[TD="align: center"]111[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]145[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]145[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]5:45:40[/TD]
[TD="align: center"]252[/TD]
[TD="align: center"]176[/TD]
[TD="align: center"]146[/TD]
[TD="align: center"]112[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]146[/TD]
[TD="align: center"]51[/TD]
[TD="align: center"]61[/TD]
[TD="align: center"]155[/TD]
[/TR]
</tbody>[/TABLE]