CDATA Issue

[habib009pk]

Dear Friends,

 

I am facing a problem I have an xml file which have various tags in which one tag is name Parsed_data having CDATA

e.g.

 

<parsed_data> <![CDATA[ <Full model name>[ Fuso, Fighter FK71GJ-760343]</Full model name> <I-auc comments>[ at preliminary inspection truck vehicle . cabin raising/ upper thing operation verification. is not possible]</I-auc comments> <NOx>[ agreement]</NOx> <air-conditioning>[AC]</air-conditioning> <bidding deadline>[2009 year08 month12 day 11 time09 minute]</bidding deadline> <capacity>[0 person]</capacity> <car history>[ renta car]</car history> <color substitution>[ ]</color substitution> <colorNO>[ ]</colorNO> <condition>[[ acceptance ended]]</condition> <drive>[ ]</drive> <equipment>[PS, PW, AB]</equipment> <exhibition>[ large size car block]</exhibition> <exterior color>[ white]</exterior color> <form>[02TR]</form> <fuel>[D]</fuel> <hall>[ BAY AUC [ Osaka (metropolitan area) Osaka city]]</hall> <holding frequency>[1522]</holding frequency> <interior color>[ ]</interior color> <loading>[2800kg]</loading> <model>[ ]</model> <special mention>[PS.PW..... airbag. dirty interior6.2 meter cut2.93 ton3 step radio controlled hook in.. inside sizeL5510...URV343.... seat tear. steering wheel worn. tappet. making a sound. carrier boarding scars, concaves.... flap scratch dent processing hole.. lower part other one part rust. scratch dent.S guard bending..... sticker peel trace.. rightF distortion of pillar.F accident.Nox agreement.....2800kg....R presence of ticket9310 jpy distance58037km]</special mention> <symbol>[KK]</symbol> <vehicle inspection "shaken">[ ]</vehicle inspection "shaken"> <year>[H14/12]</year> ]]> </parsed_data>

 

 

Now please anyone help me how can i fetch these records tag name wise

 

Thanks and regards

 

Habib Ahmad