Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SL100 QCUST parsing

Status
Not open for further replies.

magicdiablo

Technical User
Feb 19, 2010
5
US
Does anyone know how to parse out a QCUST? I would love to turn my QCUST into either a database or spreadsheet. I just don't know how to get the information parsed out the way I want it. Example data below.

I know each record is separated by a "99", but I am lost as to how to actually get the information out without doing everything manually to all ~2800 phones. Any information or ideas would be greatly appreciated.

I am not a programmer. Please do not just post scripts. I won't understand how to use it without an explanation.

Code:
99                                                                              
13 E LEN HOST  00 1 08 21 IS AN AC LEN                                          
99                                                                             
13 E LEN HOST  00 1 08 22 IS AN AC LEN                                          
99                                                                              
1 RSC2 00 1 15 26 IBN ONS 6X19AA N                                              
2 5554053 CBKS 0 14 717                                                         
9 3WC AVT DGT $                                                                 
10 0 CFX CFU N N CFBD P N P N N                                                 
10 0 CXR CTALL N STD                                                            
10 0 MWT MWL Y ALL Y                                                            
99                                                                              
1 RSC2 00 1 15 27 IBN ONS 6X17AC N                                              
2 5553940 CBKS 0 5 717                                                          
9 3WC AVT DGT $                                                                 
10 0 CXR CTALL N STD                                                            
99                                                                              
1 HOST 00 0 00 23 M5212 PONS 6X21AC N                                           
4 $                                                                             
5 1 9992011 CBKS 0 5 717 Y                                                      
9 3WC $                                                                         
10 1 NAME PUBLIC DUNHAM                                                         
5 2 5553388 CBKS 0 5 717 Y                                                      
9 3WC $                                                                         
6 3 8882748 CBKS 0 5 717 Y MCA 0 N                                              
9 3WC $                                                                         
10 6 3WC                                                                        
99                                                                              
1 HOST 00 0 15 14 M5212 PONS 6X21AC N                                           
4 $                                                                             
5 1 8882186 CBKS 0 5 717 Y                                                      
9 3WC $                                                                         
6 3 8882748 CBKS 0 5 717 Y MCA 0 N                                              
9 3WC $                                                                         
10 6 3WC                                                                        
99                                                                             
17 CBKISDN1 2   B BRAFS VOICE VBD CMD PVC FUNCTIONAL 1 DTEI TSPID 717555417301 E
KTS $ Y RSC1  00 1 05 04 $ N                                                    
1 CBKISDN1 2 ISDNKSET NPDGP BX27AA N                                            
4 64 $                                                                          
5 1 5554173 CBKS 0 5 717 Y                                                      
9 RAG LNR AVT SFC CPU CFX MWT $                                                 
10 2 AFC 1 DBC_UNDEF                                                            
10 10 MWT Y ALL Y MWL                                                           
10 13 FC 6                                                                      
10 14 DROP                                                                      
10 15 XFER CTALL                                                                
10 16 CFX CFU N N CFBD P N P N N $                                              
10 17 CPU RSC1 00 1 00 15 $ 0                                                   
10 18 RAG                                                                       
99                                                                              
17 CBKISDN1 4   B BRAFS VOICE VBD CMD PVC FUNCTIONAL 1 DTEI TSPID 717555340501 E
KTS $ Y HOST  00 1 10 06 $ N                                                    
1 CBKISDN1 4 ISDNKSET NPDGP BX27AA N                                            
4 64 $                                                                          
5 1 5553405 CBKS 0 5 717 Y                                                      
9 RAG AVT SFC CPU CFX MWT $                                                     
6 2 5554020 CBKS 0 5 717 N SCA 0 N                                              
9 RAG SFC $                                                                     
6 3 5554680 CBKS 0 5 717 N SCA 0 N                                              
9 RAG SFC $                                                                     
6 4 5554019 CBKS 0 5 717 N SCA 0 N                                              
9 RAG SFC $                                                                     
10 8 GIC   DPWDIR   09 N N                                                      
10 6 MWT Y ALL Y MWL                                                            
10 13 FC 6                                                                      
10 14 DROP                                                                      
10 15 XFER CTALL                                                                
10 16 CFX CFU N N CFBD P N P N N 1 $                                            
10 17 CPU HOST 00 1 15 11 1 $ 0                                                 
10 18 RAG
99
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top