How to extract specific data from a log txt file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need help to extract specific data from a long log file
exampl: each paragraph has parameters related to a certain date/time snapshot
how to get this in tabular format indexed by the date and time? really appreciate help.

NCEN=DOHA5 /04-02-13/08 H 39 SUBSCRIBER SAMPLE OBSERVATION
ND-DE = 4621033 TRAF = A ND-DR = 9147424157
NDA = 4621033 AFCT-DR = 205-02-04
DSO = 00006 DCO = 0000036 CE = 001 SS = 05 NE = 215-05-064

NCEN=DOHA5 /04-02-13/08 H 41 SUBSCRIBER SAMPLE OBSERVATION
ND-DE = 4621033 TRAF = A ND-DR = 9148852106
NDA = 4621033 AFCT-DR = 209-00-08
DSO = 00006 DCO = 0000097 CE = 001 SS = 05 NE = 215-05-064
 
Jad,

Import the data, then record a macro where you use Data | Text to Columns...
to expand the data out, using / as a delimiter and also (possibly) a space.
It should put the data into separate cells.

HTH,
Bernie
MS Excel MVP
 
Back
Top