Juvigy Posted July 22, 2011 Posted July 22, 2011 Hi Guys, I need help converting 19700101000000 to 1970/01/01 00:00:00 formats. I need to do NowCalc() calculations of Outlook mail received time (19700101000000) I have done it using Stringsplit and concatenations but it is ugly. Can someone help with StringRex or maybe StringFormat example ?
Moderators Melba23 Posted July 22, 2011 Moderators Posted July 22, 2011 Juvigy,Not sure an SRE would help here - it is more suited to extracting digits from the separators that adding them! How about this as a solution: Global $aSeps[7] = ["", "/", "/", " ", ":", ":", ""] $sString = "19700101000000" $sDate = "" For $i = 0 To 6 $sDate &= StringMid($sString, ($i * 2) + 1, 2) & $aSeps[$i] Next ConsoleWrite($sDate & @CRLF & "1970/01/01 00:00:00" & @CRLF)More elegant that StringSplit I hope. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Malkey Posted July 22, 2011 Posted July 22, 2011 Using StringRegExpReplace():- ;19700101000000 to 1970/01/01 00:00:00 Local $String = "19700101000000" Local $DateTime = StringRegExpReplace($String, "(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})", "\1/\2/\3 \4:\5:\6") ConsoleWrite($String & " to " & $DateTime & @LF)
Moderators Melba23 Posted July 22, 2011 Moderators Posted July 22, 2011 Malkey, <facepalm image> M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now