Home Forums SQL Server 2008 SQL Server 2008 - General Convert DD MMM YYYY to yyyymmdd in string RE: Convert DD MMM YYYY to yyyymmdd in string

  • September 30, 2013 at 5:02 am

    #1654487

    dc.pc100 (9/30/2013)

    How or where would i add the below

    Where [SourceData] like '%[0-9]%' + 'Jan' + '[0-9]%'

    as lots of data gets messed up with dwains code, and want to limit it to date specific strings only

    e.g

    Destination File Name....sourcedata2

    20130616.xlsx..............0616.xlsx

    201307.xlsx.................07.xlsx

    HSE.201306.xlsx...........HSE.06.xlsx

    HSE.201307.xlsx...........HSE.07.xlsx

    2013 ICT Calendar.xls....ICT Calendar.xls

    Inv.10017355.txt..........Optus.Inv.7355.txt

    Heh... Now you know why I said what I said in my first coded response. I kind of figured it wasn't as cleanly cut as the first bit of data.

    At this point and considering the last line in your example above, why is it that you need to converted dates embedded in a file name to a certain format?

    --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)