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:

Scan Time	A/N1	B/N2	A/N3	G/N1	G/N2	G/N3	H/N1	H/N2	H/N3
5:45:28	251	175	145	111	31	145	21	31	145
5:45:40	252	176	146	112	31	146	51	61	155

<tbody>
</tbody>