magicdiablo
Technical User
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.
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