Date Format Re-arranging

[litlmike]

I don't know what this is called, but I am just looking to change the date format from this:

Oct. 19, 2015

To 

MM/DD/YYYY

 

Is there a native way to do this in AutoIt?

[BrewManNH]

Where is the date coming from?

[UEZ]

Is this formar always the same? 

Oct. 19, 2015

-> MM. DD, YYYY 

[litlmike]

Where is the date coming from?

Long story, but it is coming from a ClipGet().  

 

Is this formar always the same? 

-> MM. DD, YYYY 

It is always the same, except that some months like May, June, and July may not have a period (".") following it.

[BrewManNH]

The clipboard must be getting the text from somewhere, what program is it coming from and can that program be made to output the date in a different format?

[litlmike]

The clipboard must be getting the text from somewhere, what program is it coming from and can that program be made to output the date in a different format?

It's coming from highlighted text in Chrome.  Psuedo:

 

MouseClick("Left", 500,500, 3)
Send("^c")
$sDate = ClipGet()

I have tried MANY ways to get this data otherwise.  So now, I am just trying to convert the dates.  Thanks.

[UEZ]

Try this:

#include <Array.au3>

$sClipboard = "Oct. 19, 2015"

ConsoleWrite(Convert($sClipboard)& @CRLF)

Func Convert($sDate) ;output MM/DD/YYYY
    Local $aMonth[13] = ["", "Jan.", "Feb.", "Mar.", "Apr.", "May", "June", "July", "Aug.", "Sep.", "Oct.", "Nov.", "Dec."]
    Return StringFormat("%02i/%02i/%4i", _
                                _ArraySearch($aMonth, StringRegExpReplace($sDate, "(.+?)\h*\d+,\h*\d+", "$1")), _
                                StringRegExpReplace($sDate, ".+\h+(\d+?),\h+\d+", "$1"), _
                                StringRegExpReplace($sDate, ".+,\h*(\d+?)", "$1"))
EndFunc

 

[litlmike]

Try this:

#include <Array.au3>

$sClipboard = "Oct. 19, 2015"

ConsoleWrite(Convert($sClipboard)& @CRLF)

Func Convert($sDate) ;output MM/DD/YYYY
    Local $aMonth[13] = ["", "Jan.", "Feb.", "Mar.", "Apr.", "May", "June", "July", "Aug.", "Sep.", "Oct.", "Nov.", "Dec."]
    Return StringFormat("%02i/%02i/%4i", _
                                _ArraySearch($aMonth, StringRegExpReplace($sDate, "(.+?)\h*\d+,\h*\d+", "$1")), _
                                StringRegExpReplace($sDate, ".+\h+(\d+?),\h+\d+", "$1"), _
                                StringRegExpReplace($sDate, ".+,\h*(\d+?)", "$1"))
EndFunc

 

Thanks!

[AdamUL]

You can also look at the Date_Time_Convert UDF by Melba23.  This is really good when you need to convert between a lot of different formats.  

#include <DTC.au3>

$sDate = "Oct. 19, 2015"

ConsoleWrite(_Date_Time_Convert($sDate, "MMM. dd, yyyy", "MM/dd/yyyy") & @CRLF)

 

Adam