Preg Match all help

weazil

Im trying to Pull a snippet of numbers or text out of a table, preg match seems to be the only way but I cant seem to figure it out. This is an example of the TD line that i would like to strip

there are many td in the table but to make it easier i set the one i need to get the data from to have a bgcolor. Im trying to pull the 200 part out of it, but that part changes it may have number, number so.

Thanks in advance

Anon

If you are wanting to pull something out, you want to use something like preg_replace.

Basically, you are looking for something that looks like this:
<td ...... bgcolor=.....>200.0</td>

And you want to replace it with:
<td ...... bgcolor=.....></td>

Is that right?

When you create your regexp, use parenthesis around parts that you want to keep. You'll find a few examples at:

http://download.php.net/manual/en/function.preg-replace.php

weazil

well thats kinda the idea... the goal is to pull 200.0 into a separate var.

with that variable Im gonna use say exec and find the corrosponding file and then parse the output into a usable link then reinject the var

doesn't seem like im asking much huh... 🙂

Anon

This is getting a mite hairy. It might be easier to do it in stages:

/*
Get the contents of the white cell.

The 'i' modifier is for case-insensitivity.

Rationale: The start of a <td> tag; followed by anything that's not a '>' (but not too much, 'cos we don't it to gobble a bgcolor= attribute; then the bgcolor= attribute we're looking for; then anything else up to the next '>' (and make sure it is the next '>'); then the '>', then we grab and store everything up to the next (not the last) </td>.
*/

preg_match('/<td[^{>]?bgcolor="#ffffff"[^>]?>(.*?)</td>/i',$table,$matches);}

/*
Now get rid of additionals tags within the cell

A '<' followed by stuff that's not a '>' followed by a '>' is replaced by an empty string.
/
$contents = preg_replace('/<[^>]?>/','',$matches[1]);

How did the 200.0 get in there in the first place?

weazil

Ok what Im working on is a Internal webpage.

on the webpage the menus are created dynamically so the ladies upstairs all they have to remember is save from word in html form into a certain folder.

for easiness cuz I doubt they will grasp on how to make a html link for the 200 thats in there or any other number that is in there for the other pages they create. I figured I would just use the intranet portal that is already pulling in their html file. Parse that number and do the linking in the bg just before the page loads. That way if the folder structure ever changes cuz its gonna use the find command to create the link it will always be linked.

weazil

Hayley

That kinda works also I had to change the / and the begining and end to |, if I set Table, like this
$table = "<TABLE><TR><TD></TD><TD WIDTH=\"26%\" VALIGN=\"MIDDLE\" BGCOLOR=\"#ffffff\" HEIGHT=8> 200.0</TD></TR></TABLE>";

that works, but if I do it pulling it from a file, it doesn't
$infotemp = "test.html";
$fd = fopen ($infotemp, "r");
$table = fread ($fd, filesize ($infotemp));
fclose ($fd);

heres what the test.html looks like, its basically a really ugly Table created in word and saved as a html file.

<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<META NAME="Generator" CONTENT="Microsoft Word 97">
<TITLE>Really Ugly Table</TITLE>
<META NAME="Template" CONTENT="C:\Program Files\Microsoft Office\Office\html.dot">
</HEAD>
<BODY LINK="#0000ff" VLINK="#800080">

<TABLE BORDER CELLSPACING=1 BORDERCOLOR="#000000" CELLPADDING=7 WIDTH=530>
<TR><TD VALIGN="TOP" COLSPAN=3 HEIGHT=25>
Protocol Test Page</TD>
</TR>
<TR><TD WIDTH="40%" VALIGN="TOP" HEIGHT=8>
TOPIC: Test Junk</TD>
<TD WIDTH="34%" VALIGN="TOP" HEIGHT=8>
Protocol Number:</TD>
<TD WIDTH="26%" VALIGN="TOP" HEIGHT=8>
10.0</TD>
</TR>
<TR><TD WIDTH="40%" VALIGN="TOP" HEIGHT=8></TD>
<TD WIDTH="34%" VALIGN="TOP" HEIGHT=8>
Issue Date :</TD>
<TD WIDTH="26%" VALIGN="TOP" HEIGHT=8>
-</TD>
</TR>
<TR><TD WIDTH="40%" VALIGN="TOP" HEIGHT=8></TD>
<TD WIDTH="34%" VALIGN="TOP" HEIGHT=8>
Reviewed/Revised:</TD>
<TD WIDTH="26%" VALIGN="TOP" HEIGHT=8>
-</TD>
</TR>
<TR><TD WIDTH="40%" VALIGN="TOP" HEIGHT=8></TD>
<TD WIDTH="34%" VALIGN="TOP" HEIGHT=8>
Related Procedure Number: </TD>
<TD WIDTH="26%" VALIGN="MIDDLE" BGCOLOR="#ffffff" HEIGHT=8>
200.0</TD>
</TR>
<TR><TD WIDTH="40%" VALIGN="TOP" HEIGHT=8></TD>
<TD WIDTH="34%" VALIGN="TOP" HEIGHT=8>
Signature:</TD>
<TD WIDTH="26%" VALIGN="TOP" HEIGHT=8>
-</TD>
</TR>
</TABLE>