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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert NSML format data in SQL table

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.
Go to Top of Page

Rajkumar7
Starting Member

2 Posts

Posted - 2013-02-25 : 00:24:56
How to convert the NSML to XML,need help!

Newcomer in SQL
Go to Top of Page
   

- Advertisement -