cobwebs in my brain, need help, please

leicaphotos

I've got 15 directories, each containing between 100 and 1000 subdirs, each containinging between 100-1000 .html files -- all .html files were machine generated with poor code:

<HTML><HEAD><TITLE>AVOCADO DIP</TITLE></HEAD>
<!--#INCLUDE VIRTUAL="includes/recads.inc"-->
<FONT SIZE=5>AVOCADO DIP<FONT SIZE=3><br>
<hr>
3 avocados coarsely mashed<br>
1 tsp. salt<br>
1 Tbsp. lemon or lime juice<br>
1 tsp. Worcestershire sauce<br>
1 clove garlic, mashed<br>
2 medium tomatoes, peeled,<br>
seeded and chopped<br>
<br>Combine all ingredients; cover and chill.<br>
<!--#INCLUDE VIRTUAL="includes/recfoot.inc"-->
</HTML>

Now, I want to have it read all files in all subdirs and beable to write one (1) master csv with the following format
title,ingredients,instructions,category

title is the text between <title> & </title>, ingredients is from the <ht> to the two <br> tags... category should be foldername (numeric)with a marking to indicate subfolder (i.e. 12|368) I've got code in place to read and display all the file names- -- how would I start approaching this -- it's been a long time since I've had to do this scale of automated file reading

any help would be appreciated

bpat1434

Sounds like you already know the regex to run:

1.) Title is the text between <title> and </title>

^.*<title>(.*)</title>

2.) Ingredients is from the <hr> to the two <br> tags

.*<hr>(.*)<br>{2}

I would run a regex on all of them as you go and just get what you need.

$cont = file_get_contents($whatever_file);
preg_match('~.*<title>(.*)</title>.*<hr>(.*)<br>[\n]<br>(.*)<!--~iU', $cont, $matches);
array_shift($matches);

I'm not guaranteeing the regex, but something very similar to that would work. The array resulting from it would be:

$matches[0] => Title
$matches[1] => Ingredients
$matches[2] => Instructions

Hope it helps....

leicaphotos

thank you -- I'm a bit closer --- ran the sample code and it's returning null values on the array -- case sensitive for the tags? just have to tweak in my preg_match

bpat1434

I didn't say it was going to be working....

THis seems to work (tested on my local dev server):

<?php

$string = '<HTML><HEAD><TITLE>AVOCADO DIP</TITLE></HEAD>
<!--#INCLUDE VIRTUAL="includes/recads.inc"-->
<FONT SIZE=5>AVOCADO DIP<FONT SIZE=3><br>
<hr>
3 avocados coarsely mashed<br>
1 tsp. salt<br>
1 Tbsp. lemon or lime juice<br>
1 tsp. Worcestershire sauce<br>
1 clove garlic, mashed<br>
2 medium tomatoes, peeled,<br>
seeded and chopped<br>
<br>Combine all ingredients; cover and chill.<br>
<!--#INCLUDE VIRTUAL="includes/recfoot.inc"-->
</HTML>';

$regexp = '~<title>(.*)</title>.*<hr>(.*)<br>[\n]<br>(.*)<!--~isU';

preg_match($regexp, $string, $matches);

array_shift($matches);

echo '<strong>Title</strong>:&nbsp;&nbsp;' . $matches[0] . '<br />
<strong>Ingredients</strong>:&nbsp;&nbsp;' . $matches[1] . '<br />
<strong>Instructions</strong>:&nbsp;&nbsp;' . $matches[2] . '<br />
<strong>Category</strong>:&nbsp;&nbsp;--Unknown--';

Outputs:

[B]Title[/B]:  AVOCADO DIP
[B]Ingredients[/B]:   3 avocados coarsely mashed
1 tsp. salt
1 Tbsp. lemon or lime juice
1 tsp. Worcestershire sauce
1 clove garlic, mashed
2 medium tomatoes, peeled,
seeded and chopped
[B]Instructions[/B]:  Combine all ingredients; cover and chill.

[b]Category[/b]:  --Unknown--

leicaphotos

that seems to have done the trick --- now I'm migrating all the data -- thanks much --- I'll be writing a php version of the code once I'm done with the .net version --- neat stuff and will share

phpnewbiedublin

nice recipe!!!!!!!!!!!