XML Parsing

M

M

<CAPI><CAPI-PARAMETERS> <CAPI-FUNCTION>inq</CAPI-FUNCTION>
<CAPI-SYSTEM>cis</CAPI-SYSTEM> <CAPI-VERSION>D</CAPI-VERSION>
<CAPI-DICTIONARY>hist</CAPI-DICTIONARY> <CAPI-MENU>hist</CAPI-MENU>
</CAPI-PARAMETERS><CAPI-MESSAGE><MSG-TYPE>ONL</MSG-TYPE><MSG-CNTL>M</MSG-CNTL><MSG-MOD>MPS</MSG-MOD><MSG-NBR>0001</MSG-NBR><MSG-TEXT>SUBSCRIBER
HAS MULTIPLE
PRODUCTS</MSG-TEXT></CAPI-MESSAGE><CAPI-DATA><CIS-MPS><PARM-LINE>40327939</PARM-LINE><PARM-CNTL
/><PARM-DATE /><FILLER
/><LOG-DATE>02/01/01</LOG-DATE><LOG-TIME>18:28:05</LOG-TIME><LOG-OPID>RLW0</LOG-OPID><ZIP-CODE>53017</ZIP-CODE><ADDRESS>4176
ELMWOOD RD</ADDRESS><UNIT-NBR /><NAME>SOBOTIK, RAYMOND MRS.</NAME><ATTN
/><CITY-NAME>COLGATE</CITY-NAME><CNTY-CODE>131</CNTY-CODE><STPV-CODE>WI</STPV-CODE><CTRY-CODE
/><ZIP-PLUS4>9702</ZIP-PLUS4><CTRY-ZIP-F>U</CTRY-ZIP-F><ACCT-FLAG>P</ACCT-FLAG><HOME-PHONE>262/628-2845</HOME-PHONE><HOME-EXTN
/><WORK-PHONE /><WORK-EXTN /><HM-PH-FLAG /><WK-PH-FLAG
/><HM-PH-LSTD>262/628-2845</HM-PH-LSTD><HM-EX-LSTD /><WK-PH-LSTD
/><WK-EX-LSTD /><BILL-CODE>PIA</BILL-CODE><PRCE-CODE /><BILL-FLAG
/><CHRG-FLAG /><CRDT-FLAG /><STAT-FLAG>C</STAT-FLAG><ALT-BILL-F /><VERIFY-F
/><NAME-TITLE /><PRZM-CODE /><ACCT-TYPE
/><ACCT-NBR>40327939</ACCT-NBR><SAM-RRN>000016772</SAM-RRN><USPO-SEQ>000000000</USPO-SEQ><DRAW-QTY>0001</DRAW-QTY><PMT-NBR>0018</PMT-NBR><CC-NBR
/><CC-EXPR-DT /><CC-USE-FLG /><BANK-NBR>000000000</BANK-NBR><BANK-NAME
/><SPRS-CODE /><STOP-RSN
/><STOP-DATE>00000000</STOP-DATE><CHRG-THRU>05/08/05</CHRG-THRU><CRDT-THRU>20050508</CRDT-THRU><TIP-AMT
/><TIP-AMRT
/><ALT-THRU>00000000</ALT-THRU><EXPR-DATE>06/22/05</EXPR-DATE><PROMO-AMT
/><DISC-AMT /><RATEH-AMT
/><BAL-AMT>24.01</BAL-AMT><START-DATE>02/03/01</START-DATE><BILL-DATE>02/13/05</BILL-DATE><PMT-DATE>03/08/05</PMT-DATE><PMT-AMT>50.05</PMT-AMT><DAZDR>SU0D01M240J212</DAZDR><SERV-CODE>DS</SERV-CODE><DRAW-CAL>11111110</DRAW-CAL><DISC-CODE>TR26-MS</DISC-CODE><SAVE-IND
/><PAPR-CODE>J</PAPR-CODE><DAZ-EDIT>SU-0D-01</DAZ-EDIT><DR-EDIT>M240-J212</DR-EDIT><PUB-DATE
/><ZIP4-FLAG /><ZIP4-SEQ>0000</ZIP4-SEQ><PRMO-CODE /><PRMO-NAME /><BLDG-ID
/><FIRM-NAME /><DCMC-CODE /><DCMC-FLAG /><OLD-ACCT
/><USPO-ZIP4>9702</USPO-ZIP4><DICT-LIST-01 ROWS="03" COLS="06" ><MPS-SELECT
ROW="1" /><MPS-ACCT ROW="1" VALUE="40327939" /><MPS-NAME ROW="1"
VALUE="SOBOTIK, RAYMOND MRS." /><MPS-PAPR ROW="1" VALUE="J" /><MPS-SERV
ROW="1" VALUE="DS" /><MPS-STAT ROW="1" VALUE="C" /><MPS-SELECT ROW="2"
/><MPS-ACCT ROW="2" VALUE="41053678" /><MPS-NAME ROW="2" VALUE="SOBOTIK,
RAYMOND" /><MPS-PAPR ROW="2" VALUE="J" /><MPS-SERV ROW="2" VALUE="SU"
/><MPS-STAT ROW="2" VALUE="F" /><MPS-SELECT ROW="3" /><MPS-ACCT ROW="3"
VALUE="11458044" /><MPS-NAME ROW="3" VALUE="SOBOTIK, JERRY" /><MPS-PAPR
ROW="3" VALUE="PM" /><MPS-SERV ROW="3" VALUE="TH2" /><MPS-STAT ROW="3"
VALUE="C" /></DICT-LIST-01></CIS-MPS></CAPI-DATA></CAPI>

I have an XML as show above. I am only able to parse the First level. Id
there any wayy i can parse the Last level of ChildNode
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?TQ==?=,

The last level of which child node? Your root node has, from what I can tell at a glance, at least two child nodes at the second level: CAPI-PARAMETERS and CAPI-MESSGAE.
<CAPI><CAPI-PARAMETERS> <CAPI-FUNCTION>inq</CAPI-FUNCTION>
<CAPI-SYSTEM>cis</CAPI-SYSTEM> <CAPI-VERSION>D</CAPI-VERSION>
<CAPI-DICTIONARY>hist</CAPI-DICTIONARY> <CAPI-MENU>hist</CAPI-MENU>
</CAPI-PARAMETERS><CAPI-MESSAGE><MSG-TYPE>ONL</MSG-TYPE><MSG-CNTL>M</MSG-CNTL><MSG-MOD>MPS</MSG-MOD><MSG-NBR>0001</MSG-NBR><MSG-TEXT>SUBSCRIBER
HAS MULTIPLE
PRODUCTS</MSG-TEXT></CAPI-MESSAGE><CAPI-DATA><CIS-MPS><PARM-LINE>40327939</PARM-LINE><PARM-CNTL
/><PARM-DATE /><FILLER
/><LOG-DATE>02/01/01</LOG-DATE><LOG-TIME>18:28:05</LOG-TIME><LOG-OPID>RLW0</LOG-OPID><ZIP-CODE>53017</ZIP-CODE><ADDRESS>4176
ELMWOOD RD</ADDRESS><UNIT-NBR /><NAME>SOBOTIK, RAYMOND MRS.</NAME><ATTN
/><CITY-NAME>COLGATE</CITY-NAME><CNTY-CODE>131</CNTY-CODE><STPV-CODE>WI</STPV-CODE><CTRY-CODE
/><ZIP-PLUS4>9702</ZIP-PLUS4><CTRY-ZIP-F>U</CTRY-ZIP-F><ACCT-FLAG>P</ACCT-FLAG><HOME-PHONE>262/628-2845</HOME-PHONE><HOME-EXTN
/><WORK-PHONE /><WORK-EXTN /><HM-PH-FLAG /><WK-PH-FLAG
/><HM-PH-LSTD>262/628-2845</HM-PH-LSTD><HM-EX-LSTD /><WK-PH-LSTD
/><WK-EX-LSTD /><BILL-CODE>PIA</BILL-CODE><PRCE-CODE /><BILL-FLAG
/><CHRG-FLAG /><CRDT-FLAG /><STAT-FLAG>C</STAT-FLAG><ALT-BILL-F /><VERIFY-F
/><NAME-TITLE /><PRZM-CODE /><ACCT-TYPE
/><ACCT-NBR>40327939</ACCT-NBR><SAM-RRN>000016772</SAM-RRN><USPO-SEQ>000000000</USPO-SEQ><DRAW-QTY>0001</DRAW-QTY><PMT-NBR>0018</PMT-NBR><CC-NBR
/><CC-EXPR-DT /><CC-USE-FLG /><BANK-NBR>000000000</BANK-NBR><BANK-NAME
/><SPRS-CODE /><STOP-RSN
/><STOP-DATE>00000000</STOP-DATE><CHRG-THRU>05/08/05</CHRG-THRU><CRDT-THRU>20050508</CRDT-THRU><TIP-AMT
/><TIP-AMRT
/><ALT-THRU>00000000</ALT-THRU><EXPR-DATE>06/22/05</EXPR-DATE><PROMO-AMT
/><DISC-AMT /><RATEH-AMT
/><BAL-AMT>24.01</BAL-AMT><START-DATE>02/03/01</START-DATE><BILL-DATE>02/13/05</BILL-DATE><PMT-DATE>03/08/05</PMT-DATE><PMT-AMT>50.05</PMT-AMT><DAZDR>SU0D01M240J212</DAZDR><SERV-CODE>DS</SERV-CODE><DRAW-CAL>11111110</DRAW-CAL><DISC-CODE>TR26-MS</DISC-CODE><SAVE-IND
/><PAPR-CODE>J</PAPR-CODE><DAZ-EDIT>SU-0D-01</DAZ-EDIT><DR-EDIT>M240-J212</DR-EDIT><PUB-DATE
/><ZIP4-FLAG /><ZIP4-SEQ>0000</ZIP4-SEQ><PRMO-CODE /><PRMO-NAME /><BLDG-ID
/><FIRM-NAME /><DCMC-CODE /><DCMC-FLAG /><OLD-ACCT
/><USPO-ZIP4>9702</USPO-ZIP4><DICT-LIST-01 ROWS="03" COLS="06" ><MPS-SELECT
ROW="1" /><MPS-ACCT ROW="1" VALUE="40327939" /><MPS-NAME ROW="1"
VALUE="SOBOTIK, RAYMOND MRS." /><MPS-PAPR ROW="1" VALUE="J" /><MPS-SERV
ROW="1" VALUE="DS" /><MPS-STAT ROW="1" VALUE="C" /><MPS-SELECT ROW="2"
/><MPS-ACCT ROW="2" VALUE="41053678" /><MPS-NAME ROW="2" VALUE="SOBOTIK,
RAYMOND" /><MPS-PAPR ROW="2" VALUE="J" /><MPS-SERV ROW="2" VALUE="SU"
/><MPS-STAT ROW="2" VALUE="F" /><MPS-SELECT ROW="3" /><MPS-ACCT ROW="3"
VALUE="11458044" /><MPS-NAME ROW="3" VALUE="SOBOTIK, JERRY" /><MPS-PAPR
ROW="3" VALUE="PM" /><MPS-SERV ROW="3" VALUE="TH2" /><MPS-STAT ROW="3"
VALUE="C" /></DICT-LIST-01></CIS-MPS></CAPI-DATA></CAPI>

I have an XML as show above. I am only able to parse the First level. Id
there any wayy i can parse the Last level of ChildNode

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :)
 

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