Stringregexp trying to capture date

[wisem2540 3]

Here is a sample of what I want to evaluate

<td class="bottomTableDate" rowspan="2">2013-05-26</td>
        <td class="bottomTableName" rowspan="2"><span class="standardTrailerName" itemprop="name">Trailer 6 - 5.1 Audio</span></td>

        <td class="bottomTableResolution"><a href="http://videos.hd-trailers.net/LONE-RANGER_TLR-6-480p-HDTN.mp4" rel="lightbox[res480p 852 480]" title="The Lone Ranger - Trailer 6 - 5.1 Audio - 480p">480p</a></td>
        <td class="bottomTableResolution"><a href="http://videos.hd-trailers.net/LONE-RANGER_TLR-6-720p-HDTN.mp4" rel="lightbox[res720p 1280 720]" title="The Lone Ranger - Trailer 6 - 5.1 Audio - 720p">720p</a></td>
        <td class="bottomTableResolution"><a href="http://videos.hd-trailers.net/LONE-RANGER_TLR-6-1080p-HDTN.mp4

END SAMPLE

 

I would like my start point to be the beginning of the file, and my end point to be one of the filenames, like the 1080p file,  I have tried alot of things.  im trying to extract the date, like this

$string = StringRegExp($i, '(\d\d\d\d-\d\d-\d\d)http://videos.hd-trailers.net/LONE-RANGER_TLR-6-1080p-HDTN.mp4', 3)
_ArrayDisplay ($string)

Im not sure if my issue is with whitespace, or something else.  Can someone point me in the right direction please?

[PhoenixXL 159]

#include <Array.au3>

$aArray = StringRegExp($sText, '(\d+-\d+-\d+)', 3)
_ArrayDisplay($aArray)

Small and limited approach.

[wisem2540 3]

Thank you, but I need the stopping point as well.  On a bigger scale, the source code will have many different movie trailers in it, each having a date before it.  So, I will need to basically start at the trailer the program has chosen, and work backwards, until it sees a date.

Thanks for the reply.

[Malkey 165]

Maybe this.

#include <Array.au3>

ConsoleWrite(StringRegExpReplace(FileRead("FullPathFileName.txt"), '(?s).+?(\d{4}-\d{2}-\d{2}).+?(http://[^"]+1080p[^"]*).+?', @LF & '\1 "\2"') & @LF)
; Or
$string = StringRegExp(FileRead("temp-378.au3"), '(\d{4}-\d{2}-\d{2}|http://.+1080p[^"]*)', 3)
_ArrayDisplay($string)

Edit: Added this example which returns the last file after a date regardless of the file's resolution.

#include <Array.au3>

Local $aArr = StringRegExp(FileRead("FullPathFileName.txt"), '(?i)(\d{4}-\d{2}-\d{2}|http://[^"]*)', 3)
_ArrayDisplay($aArr, "Date plus all links")
Local $iFlag = 1
For $i = UBound($aArr) - 1 To 0 Step -1
    If StringLeft($aArr[$i], 4) = "http" And $iFlag Then ; First http element encountered from end of array - keep
        $iFlag = 0
    ElseIf StringLeft($aArr[$i], 4) = "http" And $iFlag = 0 Then ; Subsequent http element encountered before non-http element -erase.
        _ArrayDelete($aArr, $i)
    Else
        $iFlag = 1 ; A non-http element
    EndIf
Next
_ArrayDisplay($aArr, "Date with last link")

Edited July 6, 2013 by Malkey