string operation - .NET Framework

samuelberthelot

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?

May 26 '06 #1

Subscribe Post Reply

1143

samuelberthelot

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: Ke***********@ft.com   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>

May 26 '06 #2

Ludwig

On 26 May 2006 07:16:00 -0700, sa*************@googlemail.com wrote:

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;
}

--
Ludwig Stuyck
http://www.coders-lab.be

May 26 '06 #3

Similar topics

PEP: Generalised String Coercion

by: Neil Schemenauer | last post by:

The title is perhaps a little too grandiose but it's the best I could think of. The change is really not large. Personally, I would be happy enough if only %s was changed and the built-in was...

Python

poor string function

by: ALI-R | last post by:

why c# function for string manupolation is not as strong as other languages ,for extracting a substring from a middle of another string ,I have a lot of problems. Any suggestion or I am in the...

C# / C Sharp

Fast string operations

by: Chad Myers | last post by:

I've been perf testing an application of mine and I've noticed that there are a lot (and I mean A LOT -- megabytes and megabytes of 'em) System.String instances being created. I've done some...

C# / C Sharp

Check for string absence in regex

by: varunhome | last post by:

Hi, I want to check for the absence of a string in regular expression. For example, if the string is "Error opening file: Permission denied. Aborting.", I want to check for absence of the string...

C# / C Sharp

Cast from string "2076719" to type 'Long' is not valid

by: rsine | last post by:

I have developed a program that sends a command through the serial port to our business system and then reads from the buffer looking for a number. Everything worked great on my WinXP system, but...

Visual Basic .NET

System.InvalidCastException: Cannot assign object of type System.Xml.XmlNode[] to an object of type System.String.

by: Marc | last post by:

Hi! I'm working with a C# client that calls a php web service. I've created a wrapper to call the service using .NET wsdl tool (adding a web reference). The call to the server works fine, it...

.NET Framework

Fastest way removing duplicated value from string array

by: Niyazi | last post by:

Hi all, What is fastest way removing duplicated value from string array using vb.net? Here is what currently I am doing but the the array contains over 16000 items. And it just do it in 10 or...

.NET Framework

String to integer

by: Freaker85 | last post by:

Hello, I am new at programming in C and I am searching a manner to parse a string into an integer. I know how to do it in Java, but that doesn't work in C ;o) I searched the internet but I...

C / C++

Converting const char * -> System::String^ without gcnew.

by: DaTurk | last post by:

Hi, I have several interfaces in CLI that I access via c#. My problem is, is that down in the unmanaged c++, which the CLI lies on top of, I have a lot of c_str() happening. But all of my...

.NET Framework

Strings are better than lists for the tree to string operation.

by: Bart Kastermans | last post by:

| def __str__ (self): I did some timing of operations involved. Doing this I found that the operation below to get a string representation for trees was in fact not quadratic. The final...

Python

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server