string operation

samuelberthelot · May 26, 2006

Hi,
I've got a table that contains a field of type nText.

Eeach records contains in this field the source code of a html page,
something like that...:
' <html>
<head>
<\head>
<body onload="bodyLoad()" >
<div>
<table>
<tr>
<td>
some stuff goes here
</td>
</tr>
</table>
</div>
</body>
<\html>'

I need to update the table and for each record, replace the content by
what is between the <body></body> markup (so basically, get rid off
what's not between the markup <body>)

How can I do that?

samuelberthelot · May 26, 2006

here we go, I've written the dataset to a xml file. I need to parse
this and get the content :

<FormattedText>
<FormattedTextID>230</FormattedTextID>
<Text><html> <head> <meta http-equiv=Content-Type content="text/html;
charset=windows-1252"> <meta name=Generator content="Microsoft Word 10
(filtered)"> <title>KEVIN ALLISON</title> <style> 
</style> </head> <body lang=EN-GB> <div class=Section1> <a name="OLE_LINK1"></a><a name="OLE_LINK5"></a><a
name="OLE_LINK15"></a><a name="OLE_LINK4"></a><a
name="OLE_LINK3">KEVIN (M.) ALLISON</a> Financial Times Technology Correspondent   Beat (5/06):
Computer companies and digital media   Current
(5/06): After covering the airline
industry and also writing about economic development for the Financial
Times, Mr. Allison began turning his attention to technology in October
of last year, and presumably relocated from New
York to the FT's San
Francisco bureau about
that time.   Much of his
focus is on computer makers such as Dell, Hewlett Packard and Apple,
but he also writes about other aspects of technology.   Since the
beginning of the year, he has written just two stories that were
lengthier than 1,000 words. Most of his work is short, 400-or -so- word
articles.   His two
lengthier pieces were: 
· The new internet independents - Entrepreneurship: Cheap
computing tools and hardware are giving start-ups the freedom to turn
down ... -- 4/13/06 (1,195 words) 
· A model defender for Dell. The Monday Interview with
Kevin Rollins: The head of the world's biggest PC maker has no doubts
about its flagship direct-selling strategy ... -- 3/13/06 (1,257
words)   Examples of Mr.
Allison's most recent work includes: 
· Dell drops
exclusive chip deal with Intel - 5/19/06 (306
words) 
· HP aims to reduce its costs by $1 billion - 5/18/06 (287
words) 
· Solid HP extends winning streak - 5/17/06 (332
words) 
· Yahoo picks users' brains in attempt to challenge Google -
5/17/06 (452
words) 
· Infor to acquire SSA in $1.4 billion deal - 5/16/06 (370
words) 
· Investors expect to see HP advance - 5/15/06 (420
words)   Mr. Allison has
made a few appearances on radio and TV including BBC-TV, CBS News Radio
and WABC.   Address: 251 Post
St. · San
Francisco, CA 94108   Chain of
Command (5/06): Reports to
Richard Waters, West Coast Editor   DOB: June 21,
1978 Joined: 2003 Ph: 415.445.5603
Fax: 415.445.5615 Email: (e-mail address removed)   Education: University of Missouri, B.S. - 2000;
Harvard University, M.P.P., public
policy   Employment
History (5/06): Prior to
joining the Financial Times in its New
York bureau in 2003, Mr. Allison was a research associate at
Harvard Business School where he wrote
case studies on agribusiness.   Mr. Allison also
graduated from the FT's trainee journalist program and covered
breaking news on ft.com from London.   Awards:
Mr. Allison was granted a Fulbright Scholarship in 2000 to
study biology in Austria where he
specifically looked at biotechnology in Austrian society.   PERSONAL
(5/06): Mr. Allison
appears to have spent some of his formative years in Illinois. He speaks
French and German. He enjoys reading The Economist.   ADDITIONAL
INFORMATION:   (John Batchelor Show - April 14, 2006):
Mr. Allison was a guest on the radio program to
talk about The YouTube Revolution.   (The Economist - May
1, 2004):
In a letter to The Economist "a" Kevin
Allison writes that he is an American who has taken a job in
London and
would like to know more about British "football" clubs. NewsBios
assumes that this is the same Kevin Allison of the Financial
Times.   Research
Conclusions (5/06): Our research
found no evidence of any of the following: That Mr. Allison has written
a published book; is an officer of any journalism professional groups;
won any significant journalism awards; is a regular guest on broadcast
news or public affairs programs; has been involved in any journalism
controversy of substance or has been the subject of a libel or
defamation lawsuit.     </div> </body> </html></Text>
<CreatedBy>1</CreatedBy>
<DateCreated>1900-01-02T00:00:00+00:00</DateCreated>
<LastModifiedBy>1</LastModifiedBy>
<DateLastModified>1900-01-02T00:00:00+00:00</DateLastModified>

Ludwig · May 26, 2006

Hi,
I've got a table that contains a field of type nText.

Eeach records contains in this field the source code of a html page,
something like that...:
' <html>
<head>
<\head>
<body onload="bodyLoad()" >
<div>
<table>
<tr>
<td>
some stuff goes here
</td>
</tr>
</table>
</div>
</body>
<\html>'

I need to update the table and for each record, replace the content by
what is between the <body></body> markup (so basically, get rid off
what's not between the markup <body>)

How can I do that?

string html = "<html><body>between</body></html>";
string pattern = "(<body>).*(</body>)";
Match match = Regex.Match(html, pattern);
if (match.Success)
{
string result = match.Value;
}

string operation

samuelberthelot

samuelberthelot

Ludwig