June 23, 2008 at 12:13 pm
Guys Hi,
I have a table with articleid and article_data as columns. Article_data is a column of ntext(4000) type.
Inside it contains xml code of a page containing articles. I want to extract only the text that is writen by the user and not the surrounding xml code?
is there a command extracting from a column user- data only from xml?
any ideas more than welcome! 🙂
June 23, 2008 at 2:26 pm
yes you can in many ways, but you have to provide us with a sample record first.
June 23, 2008 at 3:13 pm
Dfalir (6/23/2008)
Guys Hi,I have a table with articleid and article_data as columns. Article_data is a column of ntext(4000) type.
Inside it contains xml code of a page containing articles. I want to extract only the text that is writen by the user and not the surrounding xml code?
is there a command extracting from a column user- data only from xml?
any ideas more than welcome! 🙂
The first step is to convert the column to xml. To extract the data you could pass an xpath expression to the value method of the xml datatype. If you want the actual query you should post some sample data.
* Noel
June 24, 2008 at 12:31 am
Ok guys, thank you for your prompt reply. I wan unable to send the sample data yesterday.
the article_data column "sample" of a cell is like this:
and another one
I am sorry the user text is in Greek, but i work there! 🙂 Antything you dont understant, is Greek! 🙂
Any suggestions pls?
June 24, 2008 at 12:33 am
June 24, 2008 at 12:49 am
Guys the web page does not display on preview the sample data. I have put it within the code , /code, but still nothing appears. I tried also url still nothing. So the code is below but please replace the _ signs with the < sign
_articledata>_section id='0'>_content>_![CDATA[_P class=MsoNormal style='MARGIN: 0cm 0cm 0pt'>_SPAN style='FONT-SIZE: 14pt; FONT-FAMILY: '>?? ??a ??etast??? ???t?? ???e? ?a de? t? ?st????? t?? ?a?a??e???? p??pe? ?a ???e? t?? e??? ????se??:_/SPAN>_/P> _P class=MsoNormal style='MARGIN: 0cm 0cm 0pt'>_SPAN style='FONT-SIZE: 14pt; FONT-FAMILY: '>?p? t? µe??? ????GG????S – ?st????? ?a?a??e???? & ep????e? t?? ep???µ?t?? ?µe??µ???e?._/SPAN>_/P> _P class=MsoNormal style='MARGIN: 0cm 0cm 0pt'>_SPAN style='FONT-SIZE: 14pt; FONT-FAMILY: '>?at?e? p??? st?? pa?a??e??a p?? ???e? ?a? ß??pe? a?a??t??? t??? a???µ??? t?? ?a?t?? p?? a?t?st?????? se a?t? t?? pa?a??e??a._/SPAN>_/P>]]>_/content>_/section>_section id='1'>_content>_![CDATA[]]>_/content>_/section>_/articledata>
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply