473,597 Members | 2,113 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Extract data from table html

Hi,
I would like to extract data from the table attached.
Could someone help me to create the regular expression to grab that
informations?

TABLE:

<table border=1 cellpadding=4 cellspacing=0 width=100%><tr
bgcolor='#dcdcd c'><td align=center><b >Data</b></td><td
align=center><b >Apertura</b></td><td
align=center><b >Massimo</b></td><td align=center><b >Minimo</b></td><td
align=center><b >Chiusura</b></td><td
align=center><b >Volumi</b></td><td align=center><b >Chiusura
aggiustata*</b></td></tr><tr align=right><td
align=right><no br>20-Ottobre-03</nobr></td><td
align=right><no br>5.90</nobr></td><td
align=right><no br>5.94</nobr></td><td
align=right><no br>5.86</nobr></td><td
align=right><no br><b>5.91</b></nobr></td><td
align=right><no br>4,301,760</nobr></td><td
align=right><no br>5.91</nobr></td></tr><tr align=right><td
align=right><no br>17-Ottobre-03</nobr></td><td
align=right><no br>6.00</nobr></td><td
align=right><no br>6.01</nobr></td><td
align=right><no br>5.89</nobr></td><td
align=right><no br><b>5.91</b></nobr></td><td
align=right><no br>5,021,260</nobr></td><td
align=right><no br>5.91</nobr></td></tr><tr align=right><td
align=right><no br>16-Ottobre-03</nobr></td><td
align=right><no br>5.99</nobr></td><td
align=right><no br>6.06</nobr></td><td
align=right><no br>5.94</nobr></td><td
align=right><no br><b>5.95</b></nobr></td><td
align=right><no br>7,506,530</nobr></td><td
align=right><no br>5.95</nobr></td></tr><tr align=right><td
align=right><no br>15-Ottobre-03</nobr></td><td
align=right><no br>6.04</nobr></td><td
align=right><no br>6.09</nobr></td><td
align=right><no br>6.00</nobr></td><td
align=right><no br><b>6.02</b></nobr></td><td
align=right><no br>8,916,160</nobr></td><td
align=right><no br>6.02</nobr></td></tr></table>
Jul 17 '05 #1
1 8399
fa*****@libero. it (fadfdsj) wrote in message news:<28******* *************** ****@posting.go ogle.com>...
Hi,
I would like to extract data from the table attached.
Could someone help me to create the regular expression to grab that
informations? TABLE:

<table border=1 cellpadding=4 cellspacing=0 width=100%><tr
bgcolor='#dcdcd c'><td align=center><b >Data</b></td><td
align=center><b >Apertura</b></td><td


<snip>

You can do it, if you have http://weitz.de/regex-coach

---
"He who created the god was a fool; he who spreads his name is a
scoundrel and he who worships him is a barbarian."---Periyar, Famous
Tamil Rationalist
Email: rrjanbiah-at-Y!com
Jul 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2217
by: SteveJ | last post by:
All, Can someone help me solve the next step. First of all let me say I'm new to php. I pieced the following code together from samples I found on the net and a book I bought called PHP Cookbook. So please forgive me if this isn't the best approach - I'm open to suggestions I finally got my code to work that logs into another site and pulls the orderstatus page to my server.
10
6867
by: mark4 | last post by:
Hello, Are there any utilities to help me extract Content from HTML ? I'd like to store this data in a database. The HTML consists of about 10,000 files with a total size of about 160 Mb. Each file is a thread from a message forum. Each thread has several contributions. The threads are in linear order of date posted with filenames such as 000125633.html. The
2
2302
by: Bob | last post by:
How do I extract the value of a table field and save it to a variable of similar data type in VBA ? Thank you in advance, Bob.
1
3446
by: Ori | last post by:
Hi, I have a HTML text which I need to parse in order to extract data from it. My html contain a table contains few rows and two columns. I want to extract the data from the 2nd column in the most efficient way (using Reg Ex.) either than using the "indexOf" function of String. Thanks,
9
3492
by: chrisspencer02 | last post by:
I am looking for a method to extract the links embedded within the Javascript in a web page: an ActiveX component, or example code in C++/Pascal/etc. I am looking for a general solution, not one tailored to a particular page/script. Hopefully, the problem can be solved without recreating a complete Javascript interpreter. Any ideas?
4
3853
by: seberino | last post by:
I'm trying to extract some data from an XHTML Transitional web page. What is best way to do this? xml.dom.minidom.parseString("text of web page") gives errors about it not being well formed XML. Do I just need to add something like <?xml ...?or what? Chris
7
15724
by: Ulysse | last post by:
Hello, I'm trying to extract the data from HTML table. Here is the part of the HTML source : """ <tr> <td class="tdn" valign="top"> <input name="x44553130" value="y" type="checkbox"></td> <td class="tdn" valign="top" width="30%">
1
3063
by: veer | last post by:
Hi i am making a program in which i want to extract data from html file . Actually there are two dates on html file i want to extract these dates but the main probleum is that these dates are different on each file. A word "AKTIVA" is always comes before these dates. i made this by seaching the activa word but after this i am not getting any idea how these dates can be accessed. i use one another method by transfering the whole data of...
18
3962
by: Ecka | last post by:
Hi everyone, I'm trying to write a PHP script that connects to a bank's currency convertor page using cURL and that part works fine. The issue is that I end up with a page that includes a lot of information that I don't need. Using the PHP function strip_tags I've ended with the text below and from the remaining HTML code, I'd like to extract the lines starting with "<TABLE BORDER="1" WIDTH="315">" up to its closing </TABLEtag. How do...
0
7969
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7886
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8272
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8381
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
5431
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3886
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3927
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2404
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1238
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.