Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Rajkumar7
Starting Member
2 Posts |
Posted - 2013-02-23 : 05:47:56
|
I got below NSML data which needed to be inserted into SQL table and able indexed based on Storyid.Need help.<nsml version="-//AVID//DTD NSML 1.0//EN"><head><meta words=182 rate=180><wgroup number=1></wgroup><formname>AWANISTORYFORM</formname><storyid>209ff5a0:000373b6:46fc4389</storyid></head><story><fields><f id=title>THAILAND MYANMAR</f><f id=v-format>VOGX</f><f id=var-2></f><f id=presenter></f><f id=v-graphics>PAINT/1PG</f><f id=mos-title></f><f id=awanivideoid></f><f id=event-status></f><f id=audio-time>60</f><f id=runs-time>0</f><f id=total-time>60</f><f id=mos-duration></f><f id=cume-time></f><f id=back-time></f><f id=awanieditor></f><f id=air-date>1190937640</f><f id=endorse-by></f><f id=create-by>kaamkha</f><f id=modify-by>director</f><f id=modify-date>1190937481</f><f id=modify-dev>172.17.212.139</f><f id=mos-active></f></fields><body><p><a idref=0><pi>(ANCHOR)</pi></p><p></p><p>ASEAN SUDAH MENGHABISKAN SUMBER KEUPAYAAN BAGI MEMBAWA DEMOKRASI KE MYANMAR.</p><p></p><p>PERDANA MENTERI THAILAND, SURAYUD CHULANONT YANG MENGHADIRI SIDANG PERTUBUHAN BANGSA BERSATU, P-B-B DI NEW YORK, AMERIKA SYARIKAT, MEMBERITAHU ASEAN MEMERLUKAN BANTUAN NEGARA SERANTAU LEBIH BESAR BAGI MENGEMBALIKAN PEMERINTAHAN DEMOKRATIK.</p><p><pi></pi></p><p><pi>VOGFX</pi></p><p></p><p>JELAS BELIAU, ASEAN TIDAK PERNAH MEMINGGIRKAN MYANMAR DAN SENTIASA BERUSAHA MEMULIHKAN DEMOKRASI.</p><p></p><p>ASEAN KINI MEMERLUKAN BANTUAN PEMIMPIN LAIN KHUSUSNYA NEGARA BESAR.</p><p></p><p>BELIAU BERUCAP PADA PERHIMPUNAN ASIA SOCIETY TURUT MENJELASKAN BAHAWA ASEAN BIMBANG MENGENAI TINDAKAN KERAS JUNTA TERHADAP PENUNJUK PERASAAN.</p><p></p><p>CHULANONT TURUT MENCADANGKAN INDIA DAN CHINA MEMAINKAN PERANAN UTAMA MENYELESAIKAN KRISIS MYANMAR.</p><p></p><p>CHINA SEBELUM INI TERBABIT DALAM RUNDINGAN MEMUJUK JUNTA BERDAMAI DENGAN KEM PRO-DEMOKRASI.</p><p></p><p>TETAPI PADA MASA YANG SAMA, MENOLAK CADANGAN MEMBAWA ISU MYANMAR KE MAJLIS KESELAMATAN P-B-B.</p></body><aeset><ae id=0><ap>]] S3.0 G 0 [[</ap><mc><ap>CG AS001 REAKSI NEGARA ASEAN</ap></mc></ae></aeset></story>Newcomer in SQL |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-23 : 09:34:46
|
SQL has capabilities to handle XML data. The sample you posted does not seem to be well-formed XML. If there are NSML to XML converters that you can use to convert the data to valid XML that you are aware of, then convert the NSML to XML and then SQL can be used to shred and/or query the XML. |
|
|
Rajkumar7
Starting Member
2 Posts |
Posted - 2013-02-25 : 00:24:56
|
How to convert the NSML to XML,need help!Newcomer in SQL |
|
|
|
|
|