Picking up particular data from flat file

P

ppc

Following is the sample txt file.I want to pick following values in a table
with same column names.
1.ND = 2310000 to 2319999
2.L1
3.L2
4.L3
5.L4
6.L5
7.L6
8.L7
9.L8

TXT File =>
Pls Note=> For each ND value there are individual L1 to L8 values.

@ESAB:
CEN=1/08-12-10/18 H 27 MN 29/TEST ON A SUBSCRIBER LINE
@ND=2310000:
PROCESSING TELDMS ACC
*ND= 2310000 NE=004-20-001 NROB=132 TY=GABA1+KLA STATUS=LIBR
L1= 0 V L2= 0 V L3= 0.0 V L4=- 0.5 V
L5> 1016 KO L6> 1016 KO L7> 1016 KO * L8= 2.10 MI

PROCESSING TELDMS EXC
@ND=2310004:
PROCESSING TELDMS ACC
ND= 2310004 NE=003-17-022 NROB=131 TY=GABA1+KLA STATUS=LIBR
L1= 0 V L2= 0 V L3=- 0.5 V L4= 0.0 V
L5= 672 KO L6> 1016 KO L7> 1016 KO L8= 0.45 MI

PROCESSING TELDMS EXC
@ND=2310007:
PROCESSING TELDMS ACC
*ND= 2310007 NE=004-07-037 NROB=132 TY=GABA1+KLA STATUS=LIBR
L1= 0 V L2= 0 V * L3=- 21.0 V L4=- 1.0 V
* L5= 32 KO L6> 1016 KO L7> 1016 KO * L8= 1.40 MI

PROCESSING TELDMS EXC
@ND=2310008:
PROCESSING TELDMS ACC
*ND= 2310008 NE=003-15-060 NROB=131 TY=GABA1+KLA STATUS=LIBR
L1= 0 V L2= 0 V * L3=- 16.5 V L4=- 2.0 V
* L5= 48 KO * L6= 120 KO * L7= 168 KO L8= 0.90 MI

PROCESSING TELDMS EXC
@ND=2310015:
PROCESSING TELDMS ACC
*ND= 2310015 NE=003-17-028 NROB=131 TY=GABA1+KLA STATUS=LIBR
L1= 0 V L2= 0 V L3=- 1.0 V L4=- 0.5 V
* L5= 184 KO L6> 1016 KO L7> 1016 KO L8= 0.20 MI

PROCESSING TELDMS EXC

Regds,

Prasanna
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top