Removing jargon from span fields

[Blinger]

Hello.

Basically I have a whole heap of documents that are filled with jargon like this:

<span class="xdTextBox" hidefocus="1" title="" tabindex="0" xd:binding="my:Ingredient" xd:ctrlid="CTRL17" xd:xctname="PlainText" style="BORDER-RIGHT: #dcdcdc 1pt; BORDER-TOP: #dcdcdc 1pt; FONT-WEIGHT: normal; FONT-SIZE: x-small; BORDER-LEFT: #dcdcdc 1pt; WIDTH: 100%; COLOR: #000000; BORDER-BOTTOM: #dcdcdc 1pt; FONT-STYLE: normal; FONT-FAMILY: Verdana; HEIGHT: 20px; TEXT-DECORATION: none">100% Wholemeal Flour</span> 

and I want to get rid of everything except the part that says 100% Wholemeal Flour at the very end so I can run it on multiple files and then insert it into a DB (that's the easy part, getting the text is hard). There is a table of between 3 and 10 ingredients depending on the recipe and each row has 6 columns. The first 2 are important.

Any help at all will be appreciated.

[eLv]

You tried strip_tags yet?

http://uk.php.net/strip_tags

[Blinger]

You tried strip_tags yet?

http://uk.php.net/strip_tags

Yep. Didn't work. Makes the result turn out like this:

Multi Grain Dough Ingredients%KgKgKgKgBakers Flour751.5003.7507.50018.750Multi Grain Mix250.5001.2502.5006.250

The 751.5003.7507.50018.750 is all meant to be seperate values i.e. (Multi Grain Mix 25 0.500 1.250 2.500 6.250)

[eLv]

Maybe showing one of the document would be helpful, letting us know what the conditions we need to use to extract the info.

[Blinger]

Maybe showing one of the document would be helpful, letting us know what the conditions we need to use to extract the info.

Here is a document. It is a Microsoft Sharepoint page but I don't have that so I need to rip out the first and second column (ingredients and percentages).
Edit: use this link http://pastebin.com/zKtU1xfV

[eLv]

The html is in a mess, haha. This can be easily done with simplehtmldom though, if you never heard of it before: http://simplehtmldom.sourceforge.net/

<?php

    require_once( 'simple_html_dom.php' ); // The dom class file
    
    $file = file_get_html( 'linkto.html' ); // Get the html, this can be linked to a url too
    
    $ingre['title'] = $file->find( 'span[xd:binding=my:RecipeTitle]', 0 )->innertext; // Find the title
    
    // The main ingredient was different from those subs, so use this to get them
    $ingre['mainIngre']['name'] = strip_tags( $file->find( 'table[xd:ctrlid=CTRL21] tr[style] td', 0 )->innertext );
    $ingre['mainIngre']['perc'] = strip_tags( $file->find( 'table[xd:ctrlid=CTRL21] tr[style] td', 0 )->next_sibling()->innertext ); 
    
    // Now get the sub ingredient and put them into arrays
    foreach( $file->find( 'table[xd:ctrlid=CTRL21] tr[style]' ) as $tr ) {
        $ingreName = ( @$tr->find( 'span[xd:binding=my:Ingredient]', 0 )->innertext ) ? : false;
        $ingrePerc = ( @$tr->find( 'span[xd:binding=myercentage]', 0 )->innertext ) ? : false;
        if( $ingreName || $ingrePerc ) {
            $ingre['subIngre'][] = array(
                "name" => $ingreName,
                "perc" =>  $ingrePerc . '%'
           &nbsp;
        }
    }
    
?>
<pre>
<?php
    print_r( $ingre );
?>
</pre>

Just use the same conditions if you want to extract the rest of the details, view the source of the html file and play the codes from there.

The fun of programming.

[Blinger]

The html is in a mess, haha. This can be easily done with simplehtmldom though, if you never heard of it before: http://simplehtmldom.sourceforge.net/

<?php

    require_once( 'simple_html_dom.php' ); // The dom class file
    
    $file = file_get_html( 'linkto.html' ); // Get the html, this can be linked to a url too
    
    $ingre['title'] = $file->find( 'span[xd:binding=my:RecipeTitle]', 0 )->innertext; // Find the title
    
    // The main ingredient was different from those subs, so use this to get them
    $ingre['mainIngre']['name'] = strip_tags( $file->find( 'table[xd:ctrlid=CTRL21] tr[style] td', 0 )->innertext );
    $ingre['mainIngre']['perc'] = strip_tags( $file->find( 'table[xd:ctrlid=CTRL21] tr[style] td', 0 )->next_sibling()->innertext ); 
    
    // Now get the sub ingredient and put them into arrays
    foreach( $file->find( 'table[xd:ctrlid=CTRL21] tr[style]' ) as $tr ) {
        $ingreName = ( @$tr->find( 'span[xd:binding=my:Ingredient]', 0 )->innertext ) ? : false;
        $ingrePerc = ( @$tr->find( 'span[xd:binding=myercentage]', 0 )->innertext ) ? : false;
        if( $ingreName || $ingrePerc ) {
            $ingre['subIngre'][] = array(
                "name" => $ingreName,
                "perc" =>  $ingrePerc . '%'
           &nbsp;
        }
    }
    
?>
<pre>
<?php
    print_r( $ingre );
?>
</pre>

Just use the same conditions if you want to extract the rest of the details, view the source of the html file and play the codes from there.

The fun of programming.

I know. So frustrating and it can only be viewed in internet explorer otherwise the bottom half mucks up. What have the developers done!? Gar!