Post reply

Parse multiple dates from Text Field

  • May 26, 2009 at 9:56 am

    #999987

    EXCELLENT!!!! Thank you VERY much Flo! Your code to extract the dates worked exactly right! I'll use this as the base for extracting the associated text.

    And thank for your added recommendation Jeff.

  • May 26, 2009 at 10:10 am

    #1000001

    Glad that we could help 🙂

  • May 26, 2009 at 1:56 pm

    #1000168

    Tim Daly (5/26/2009)

    EXCELLENT!!!! Thank you VERY much Flo! Your code to extract the dates worked exactly right! I'll use this as the base for extracting the associated text.

    And thank for your added recommendation Jeff.

    Thanks, Tim. As a reminder, keep in mind that the Tally table that Flo was good enought to provide only goes up to 11,000 bytes... make sure that's enough for your TEXT datatype column.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply