FLAGS          : FIRST      CHARGE     ANSWER     CONN                 
 OWNER DN       : 1292433355                                            
 CALLING PARTY  : 1292433355                                            
 NADI: 3  =NATIONAL NUMBER        NPI: 1=ISDN NUMBERING PLAN 
 SCR.IND.: 3=NETWORK PROVIDED         PRES.IND.: 0=ALLOWED       
 CALLED PARTY   : 61434045186                                           
 NADI: 4  =INTERNATIONAL NUMBER   NPI: 1=ISDN NUMBERING PLAN 
 DATE TIME DURAT: 2011-09-05  08:55:08 0   ENDTIME SECURE       1194 SEC
 PARTNER DN     : 0061434045186                                         
 ZONE/CHARGEBAND: ZONE= 33   CHB=                                       
 CHARGE UNITS   : CONN= 200                         
 CONNECTION ID  : H'7D08282E   
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
I would install grep for windows  http://gnuwin32.sourceforge.net/packages/grep.htm  or cygwin https://www.cygwin.com/

either way from the command prompt you can filter the text file and pull the lines you need

grep for windows
type filename | grep -i -e "owner dn" -e "date time durat" -e "partner dn" -e "zone/charge" -e "charge units" > newfile

cygwin
cat filename  | grep -i -e "owner dn" -e "date time durat" -e "partner dn" -e "zone/charge" -e "charge units" > newfile

either way newfile ends up with the highlighted data you were looking for.
| grep -i -e "owner dn" -e "date time durat" -e "partner dn" -e "zone/charge" -e "charge units" > newfile - See more at: http://www.itninja.com/question/how-to-filter-out-keyword-values-from-a-text-file-so-that-we-can-make-excel-sheet-i-have-highlighted-the-values-which-i-need-in-excel-sheet#sthash.qU2s26pA.dpuf
Answered 08/08/2014 by: genfoch01
Orange Senior Belt

Please log in to comment
Answer this question or Comment on this question for clarity