Crayfish

Thank you Terenz. I was attempting with _IEDocReadHTML Dim $sSrc = _IEDocReadHTML($oIE) Dim $aMatch = StringRegExp($sSrc, '(?:<span class="a-size-base a-color-secondary review-date">)(.*?)(?:</span>)', 3) Is there a command to search for the date in the source after a specific id/tag only? Amazon added 2 sticky reviews in iframe and sometime 3 Example: https://www.amazon.com/One-Persons-Craziness-R-T-Ojas-ebook/product-reviews/B01BGFBUC4/ref=cm_cr_arp_d_viewopt_sr?ie=UTF&showViewpoints=1&sortBy=bySubmissionDateDescending&filterByStar=all_stars&pageNumber=1 Pull after the last actual review and not the top critic, or top comments, or top positive.

<?php include('simple_html_dom.php'); //Html dom parser from: https://sourceforge.net/projects/simplehtmldom/files/simple_html_dom.php $product_id= "B01BGFBUC4"; //Amazon product ID $url = "http://www.amazon.com/One-Persons-Craziness-R-T-Ojas-ebook/product-reviews/".$product_id."/ref=cm_cr_dp_see_all_btm?ie=UTF8&showViewpoints=1&sortBy=bySubmissionDateDescending&filterByStar=two_star"; $html = file_get_html($url); $ret = $html->find('div[id=cm_cr-review_list] span[class=a-size-base a-color-secondary review-date]', 0); $amazonReviewCount = $ret->innertext; echo "$amazonReviewCount"; ?> Result: on February 28, 2016 Is there a way to do this just natively in Autoit?

Water, Thanks for the assist and I couldn't reply thanks to PM. Mine seems to be over complicated. #include <OutLookEX.au3> Global $aItems, $Result Global $oOutlook = _OL_Open() Global $oOApp = ObjCreate("Outlook.Application") Global $aFolder = _OL_FolderAccess($oOutlook, "*Inbox", Default, Default) Global $sFilter = "@SQL=(""urn:schemas:httpmail:hasattachment"" = 1 AND ""urn:schemas:httpmail:read"" = 0)" $aItems = _OL_ItemSearch($oOutlook, $aFolder[1], $sFilter, "EntryID") ;~ $aItems = _OL_ItemFind($oOutlook, $vOlFolder, $olMail, "[UnRead]=True", "", "", "EntryID", "") If IsArray($aItems) Then For $i = 1 To $aItems[0][0] $Result = _OL_ItemAttachmentGet($oOutlook, $aItems[$i][0], Default) ;mark as read first to prevent read receipt confusion massacre _OL_ItemModify($oOutlook, $aItems[$i][0], Default, "UnRead=False") Global $oOL_Item = $oOApp.Session.GetItemFromID($aItems[$i][0], Default) Global $var = $oOL_Item.Subject If IsArray($Result) Then For $r = 1 To $Result[0][0] _OL_ItemAttachmentSave($oOutlook, $aItems[$i][0], Default, 1, "c:outlook" & $var & "" & $Result[$r][1]) Next Else ;YAY! EndIf Next Else MsgBox(48, "OutlookEX UDF: _OL_ItemFind Example Script", "Could not find an unread mail. @error = " & @error & ", @extended: " & @extended) EndIf

You shouldn't mask the new password without a second validation that the user had actually type new password or what they think they typed are two different thing. The error never get trigger for SQL because you don't have any error handler. Default script crashed before it reach your @error

Is there anyway you can adapt this for newer ODBC? This crash for me on win7 x64 with office 2010 and office 2007 accdb file.

Thank you for these exceptional detailed examples. I just want to leave a note that these examples are extremely well cared for examples! I will try it when I'm back at work.

Water - I wish I can vote for all examples. They seem to be useful.

Malkey - Excellent work Malkey and thank you for continuing assist. I never knew how something so simple as sorting date can turn out to be so tripping. I really love your simplistic date parse sort comparation. This is very useful to compare array dates. You should promote this into a mini snippet or UDF and I know it will assist million people. MilesAhead - That's seem to do a lot of overhead no?

Jury: Thank you for trying but your humble idea my bad attempt. Needless to say I did took it into consideration and tried it out. See it for yourself. _DayValueToDate value back to date no longer hold it integrity and original date and estimate Gregorian date is no longer match. Make mistake on my part for rushing. Seems to work ok when I tried again. #include <Date.au3> #include <Array.au3> SORT() Func SORT() ;=============================================================================== ; Stubborn Date Sort ;=============================================================================== Local $avArray[11][5]= _ [["3/04/2010","03","04","20","10"], _ ["04/1/2011","04","01","20","11"], _ ["03/05/2010","03","05","20","10"], _ ["2/30/2012","02","30","20","12"], _ ["1/1/2001","1","1","20","01"], _ ["04/2/2011","04","02","20","11"], _ ["02/7/2011","02","7","20","11"], _ ["03/06/2010","03","06","20","10"], _ ["04/31/2007","04","31","20","07"], _ ["3/31/2007","TEST","TEST","TEST","TEST"], _ ["04/03/2011","04","03","20","11"]] Local $DMYHolder Local $Y, $M, $D _ArrayDisplay($avArray) For $i = 0 To UBound($avArray,1) - 1 $DMYHolder = _DateToDayValueArray($avArray[$i][0]) $avArray[$i][0] = _DateToDayValue($DMYHolder[3],$DMYHolder[1],$DMYHolder[2]) Next _ArraySort($avArray) For $i = 0 To UBound($avArray,1) - 1 $avArray[$i][0] = _DayValueToDate($avArray[$i][0], $Y, $M, $D) Next _ArrayDisplay($avArray) EndFunc Func _DateToDayValueArray($sDate) ;Turn date into array Local $TimeArray = StringSplit ( $sDate, "/" ) Return $TimeArray EndFunc Malkey: Thank you I tried that but it seems to tripping out with me and sort seems to not work as intended. #AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 #include <Array.au3> #include <GUIConstantsEx.au3> #include <GuiListView.au3> #include <GuiImageList.au3> #include <WindowsConstants.au3> Opt("GUIOnEventMode", 1) ; 1 = enable. Opt("GUICloseOnESC", 1) ; 1 = Send the $GUI_EVENT_CLOSE message when ESC is pressed (default). Opt('MustDeclareVars', 1) Global $hListView _Example1() While 1 Sleep(3000) WEnd Func _Example1() GUICreate("ListView Sort", 300, 400) GUISetOnEvent($GUI_EVENT_CLOSE, "CloseGUI") $hListView = GUICtrlCreateListView("DATE|INC1|INC2|INC3|INC4", 10, 10, 280, 380) GUICtrlSetOnEvent($hListView, "sort") _AddRow($hListView, "03/04/2010|03|04|20|10") _AddRow($hListView, "04/01/2011|04|01|20|11") _AddRow($hListView, "1/1/2001|1|1|20|01") _AddRow($hListView, "02/30/2012|02|30|20|12") _AddRow($hListView, "04/02/2011|04|02|20|11") _AddRow($hListView, "02/7/2011|02|7|20|11") _AddRow($hListView, "04/31/2007|04|31|20|07") _AddRow($hListView, "3/31/2007|----|----|----|----") _AddRow($hListView, "04/03/2011|04|03|20|11") GUISetState() _GUICtrlListView_RegisterSortCallBack($hListView) EndFunc ;==>_Example1 Func sort() Local $iCol = GUICtrlGetState($hListView) ; ----- If the column clicked contains date formated "MM/DD/YYYY" then convert to date format "YYYY/MM/DD" ---- If StringRegExp(_GUICtrlListView_GetItemText($hListView, 0, $iCol), "(d{2})[/.-](d{2})[/.-](d{4})") Then Local $iRowCount = _GUICtrlListView_GetItemCount(ControlGetHandle("ListView Sort", "", $hListView)) Local $aItem2D[$iRowCount][2], $aTemp For $i = 0 To $iRowCount - 1 $aItem2D[$i][0] = _GUICtrlListView_GetItemText($hListView, $i, $iCol) $aTemp = StringRegExp($aItem2D[$i][0], "(d+)", 3) $aItem2D[$i][1] = StringFormat("%4d/%02d/%02d", $aTemp[2], $aTemp[0], $aTemp[1]) _GUICtrlListView_SetItem($hListView, $aItem2D[$i][1], $i, $iCol) Next ; -------- Sort all columns ---------- _GUICtrlListView_SortItems($hListView, $iCol) ; -------- Convert date format "YYYY/MM/DD" back to the original format -------- For $i = 0 To $iRowCount - 1 For $j = 0 To $iRowCount - 1 If StringCompare(_GUICtrlListView_GetItemText($hListView, $i, $iCol), $aItem2D[$j][1]) = 0 Then _GUICtrlListView_SetItem($hListView, $aItem2D[$j][0], $i, $iCol) ExitLoop 1 EndIf Next Next Else _GUICtrlListView_SortItems($hListView, $iCol) EndIf EndFunc ;==>sort Func _AddRow($hWnd, $sItem) Local $aItem = StringSplit($sItem, "|") Local $iIndex = _GUICtrlListView_AddItem($hWnd, $aItem[1]) For $x = 2 To $aItem[0] _GUICtrlListView_AddSubItem($hWnd, $iIndex, $aItem[$x], $x - 1) _GUICtrlListView_SetColumnWidth($hWnd, $x - 1, $LVSCW_AUTOSIZE) Next EndFunc ;==>_AddRow Func CloseGUI() _GUICtrlListView_UnRegisterSortCallBack($hListView) GUIDelete() Exit EndFunc ;==>CloseGUI

Thank you JScript - This UDF is incredible. Keep up the great work.

Hidden column seem too much work. I have taken all your good ideas jdelaney, kafu, malkey and combined to reverse the date temporarily to sort and put it back. Here is the result. Seem to work except 1 problem _ Check the array I put TEST and see March still fall short of April due to leading '0'. Any suggestion? Another string parsing for date consistency? How would I go about filter this date range to show only specific range - from/to before/after? Semi Functional Resolution: #include <Array.au3> SORT() Func SORT() ;=============================================================================== ; Stubborn Date Sort ;=============================================================================== Local $avArray[11][5]= _ [["03/04/2010","03","04","20","10"], _ ["04/01/2011","04","01","20","11"], _ ["03/05/2010","03","05","20","10"], _ ["02/30/2012","02","30","20","12"], _ ["1/1/2001","1","1","20","01"], _ ["04/02/2011","04","02","20","11"], _ ["02/7/2011","02","7","20","11"], _ ["03/06/2010","03","06","20","10"], _ ["04/31/2007","04","31","20","07"], _ ["3/31/2007","TEST","TEST","TEST","TEST"], _ ["04/03/2011","04","03","20","11"]] _ArrayDisplay($avArray) For $i = 0 To UBound($avArray,1) - 1 $avArray[$i][0] = _YMD($avArray[$i][0]) Next _ArraySort($avArray) For $i = 0 To UBound($avArray,1) - 1 $avArray[$i][0] = _MDY($avArray[$i][0]) Next _ArrayDisplay($avArray) EndFunc Func _MDY($sDate) ; YYYY/MM/DD >> MM/DD/YYYY Return StringRegExpReplace ( $sDate, "(d*)/(d*)/(d*)", "$2/$3/$1" ) EndFunc Func _YMD($sDate) ; MM/DD/YYYY >> YYYY/MM/DD Return StringRegExpReplace ( $sDate, "(d*)/(d*)/(d*)", "$3/$1/$2" ) EndFunc

KaFu: I never knew about hidden column with GuiLV - I will look up regard this. Might be the only way to resolve this. It's not possible for me to use European date format. Malkey: Your function work for 1D array Is there a way to keep the relationship with 2D array? #AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 #include <Array.au3> #include <GUIConstantsEx.au3> #include <GuiListView.au3> #include <GuiImageList.au3> #include <WindowsConstants.au3> Opt("GUIOnEventMode", 1) ; 1 = enable. Opt("GUICloseOnESC", 1) ; 1 = Send the $GUI_EVENT_CLOSE message when ESC is pressed (default). Opt('MustDeclareVars', 1) Global $hListView _Example1() While 1 Sleep(3000) WEnd Func _Example1() Local $hImage, $aIcons[3] = [0, 3, 6] Local $iExWindowStyle = BitOR($WS_EX_DLGMODALFRAME, $WS_EX_CLIENTEDGE) Local $iExListViewStyle = BitOR($LVS_EX_FULLROWSELECT, $LVS_EX_SUBITEMIMAGES, $LVS_EX_GRIDLINES, $LVS_EX_CHECKBOXES, $LVS_EX_DOUBLEBUFFER) GUICreate("ListView Sort", 300, 400) GUISetOnEvent($GUI_EVENT_CLOSE, "CloseGUI") $hListView = GUICtrlCreateListView("Column1|Column2", 10, 10, 280, 380, -1, $iExWindowStyle) _GUICtrlListView_SetExtendedListViewStyle($hListView, $iExListViewStyle) GUICtrlSetOnEvent($hListView, "sort") ; Load images $hImage = _GUIImageList_Create(18, 18, 5, 3) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -7) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -12) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -3) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -4) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -5) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -6) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -9) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -10) _GUIImageList_AddIcon($hImage, @SystemDir & "shell32.dll", -11) _GUICtrlListView_SetImageList($hListView, $hImage, 1) _AddRow($hListView, "10/20/2001|2", $aIcons) GUISetState() _GUICtrlListView_RegisterSortCallBack($hListView) _AddRow($hListView, "12/15/2000|1", $aIcons) _AddRow($hListView, "04/05/2004|3", $aIcons) _AddRow($hListView, "1/22/2004|4", $aIcons) _AddRow($hListView, "11/05/2005|5", $aIcons) _AddRow($hListView, "8/15/2004|6", $aIcons) _AddRow($hListView, "10/05/2008|7", $aIcons) _AddRow($hListView, "11/05/2012|8", $aIcons) _AddRow($hListView, "12/05/2012|9", $aIcons) ; ---------------- Sort ------------------------ Local $iCount = _GUICtrlListView_GetItemCount(ControlGetHandle("ListView Sort", "", $hListView)) Local $aItem2D[$iCount][2], $aTemp For $i = 0 To $iCount - 1 $aItem2D[$i][0] = _GUICtrlListView_GetItemText($hListView, $i) $aTemp = StringRegExp($aItem2D[$i][0], "(d+)", 3) $aItem2D[$i][1] = StringFormat("%4d/%02d/%02d", $aTemp[2], $aTemp[0], $aTemp[1]) Next _ArraySort($aItem2D, 1, 0, 0, 1) For $i = 0 To $iCount - 1 _GUICtrlListView_SetItem($hListView, $aItem2D[$i][0], $i) Next ; ------------ End of Sort ------------------------ EndFunc ;==>_Example1 Func sort() _GUICtrlListView_SortItems($hListView, GUICtrlGetState($hListView)) EndFunc ;==>sort Func _AddRow($hWnd, $sItem, $aIcons, $iPlus = 0) Local $aItem = StringSplit($sItem, "|") Local $iIndex = _GUICtrlListView_AddItem($hWnd, $aItem[1], $aIcons[0] + $iPlus, _GUICtrlListView_GetItemCount($hWnd) + 9999) _GUICtrlListView_SetColumnWidth($hWnd, 0, $LVSCW_AUTOSIZE_USEHEADER) For $x = 2 To $aItem[0] _GUICtrlListView_AddSubItem($hWnd, $iIndex, $aItem[$x], $x - 1, $aIcons[$x - 1] + $iPlus) _GUICtrlListView_SetColumnWidth($hWnd, $x - 1, $LVSCW_AUTOSIZE) Next EndFunc ;==>_AddRow Func CloseGUI() _GUICtrlListView_UnRegisterSortCallBack($hListView) GUIDelete() Exit EndFunc ;==>CloseGUI

I can't do that with a 2D arrays it will mess up the order in relation with. Any other idea?

I have tried everything to sort dates within an array. It's always sort incorrectly. I have tried compare $1 < $2 or $1>$2 and shift the order down the row but that doesn't help when there a date down the list still wrong. Anyone has any suggestion or logic - please point me to the right direction. Here is a quick example to test. Thank you in advance. SOLVED EXAMPLE - By Malkey #AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 #include <Array.au3> #include <GUIConstantsEx.au3> #include <GuiListView.au3> #include <GuiImageList.au3> #include <WindowsConstants.au3> Opt("GUIOnEventMode", 1) ; 1 = enable. Opt("GUICloseOnESC", 1) ; 1 = Send the $GUI_EVENT_CLOSE message when ESC is pressed (default). Opt('MustDeclareVars', 1) Global $hListView _Example1() While 1 Sleep(100) WEnd Func _Example1() ;Local $hImage Local $iExWindowStyle = BitOR($WS_EX_DLGMODALFRAME, $WS_EX_CLIENTEDGE) Local $iExListViewStyle = BitOR($LVS_EX_FULLROWSELECT, $LVS_EX_GRIDLINES, $LVS_EX_DOUBLEBUFFER) GUICreate("ListView Sort", 300, 400) GUISetOnEvent($GUI_EVENT_CLOSE, "CloseGUI") $hListView = GUICtrlCreateListView("Column1|Column2|Column3|Col4", 10, 10, 280, 380, -1, $iExWindowStyle) _GUICtrlListView_SetExtendedListViewStyle($hListView, $iExListViewStyle) GUICtrlSetOnEvent($hListView, "sort") _AddRow($hListView, "10/20/2001|2|7|10/14/2012") _AddRow($hListView, "12/15/2000|1|8|5/22/2012") _AddRow($hListView, "04/05/2004|----|----|----") _AddRow($hListView, "1/22/2004|4|6|1/4/2012") _AddRow($hListView, "11/05/2005|5|3|10/12/2012") _AddRow($hListView, "8/15/2004|6|2|10/10/2010") _AddRow($hListView, "10/05/2008|7||11/11/2011") _AddRow($hListView, "11/05/2012|8|4|05/15/2005") _AddRow($hListView, "12/05/2012|9|5|1/21/2004") GUISetState() _GUICtrlListView_RegisterSortCallBack($hListView) EndFunc ;==>_Example1 Func sort() Local $iCol = GUICtrlGetState($hListView) Local $iRowCount = _GUICtrlListView_GetItemCount(ControlGetHandle("ListView Sort", "", $hListView)) ; ----- If the column clicked contains date formated "MM/DD/YYYY" in the first, middle, or last ; row, then convert to date format "YYYY/MM/DD" ---- If StringRegExp(_GUICtrlListView_GetItemText($hListView, 0, $iCol), "(d{1,2})[/.-](d{1,2})[/.-](d{4})") Or _ StringRegExp(_GUICtrlListView_GetItemText($hListView, $iRowCount - 1, $iCol), "(d{1,2})[/.-](d{1,2})[/.-](d{4})") Or _ StringRegExp(_GUICtrlListView_GetItemText($hListView, Int($iRowCount / 2), $iCol), "(d{1,2})[/.-](d{1,2})[/.-](d{4})") Then Local $aItem2D[$iRowCount][2], $aTemp For $i = 0 To $iRowCount - 1 $aItem2D[$i][0] = _GUICtrlListView_GetItemText($hListView, $i, $iCol) If StringRegExp($aItem2D[$i][0], "(d{1,2})[/.-](d{1,2})[/.-](d{4})") Then $aTemp = StringRegExp($aItem2D[$i][0], "(d+)", 3) $aItem2D[$i][1] = StringFormat("%4d/%02d/%02d", $aTemp[2], $aTemp[0], $aTemp[1]) _GUICtrlListView_SetItem($hListView, $aItem2D[$i][1], $i, $iCol) Else $aItem2D[$i][1] = $aItem2D[$i][0] _GUICtrlListView_SetItem($hListView, $aItem2D[$i][1], $i, $iCol) EndIf ;ConsoleWrite($aItem2D[$i][0] & " " & $aItem2D[$i][1] & @LF) Next ;ConsoleWrite(@LF) ; -------- Sort all columns ---------- _GUICtrlListView_SortItems($hListView, $iCol) ; -------- Convert date format "YYYY/MM/DD" back to the original format -------- For $i = 0 To $iRowCount - 1 For $j = 0 To $iRowCount - 1 If StringCompare(_GUICtrlListView_GetItemText($hListView, $i, $iCol), $aItem2D[$j][1]) = 0 Then _GUICtrlListView_SetItem($hListView, $aItem2D[$j][0], $i, $iCol) ExitLoop 1 EndIf Next Next Else _GUICtrlListView_SortItems($hListView, $iCol) EndIf EndFunc ;==>sort Func _AddRow($hWnd, $sItem) Local $aItem = StringSplit($sItem, "|"), $iColWidth Local $iIndex = _GUICtrlListView_AddItem($hWnd, $aItem[1], -1, _GUICtrlListView_GetItemCount($hWnd)) _GUICtrlListView_SetColumnWidth($hWnd, 0, $LVSCW_AUTOSIZE_USEHEADER) For $x = 2 To $aItem[0] _GUICtrlListView_AddSubItem($hWnd, $iIndex, $aItem[$x], $x - 1) _GUICtrlListView_SetColumnWidth($hWnd, $x - 1, $LVSCW_AUTOSIZE) $iColWidth = _GUICtrlListView_GetColumnWidth($hWnd, $x - 1) _GUICtrlListView_SetColumnWidth($hWnd, $x - 1, $LVSCW_AUTOSIZE_USEHEADER) If $iColWidth > _GUICtrlListView_GetColumnWidth($hWnd, $x - 1) Then _GUICtrlListView_SetColumnWidth($hWnd, $x - 1, $LVSCW_AUTOSIZE) EndIf Next EndFunc ;==>_AddRow Func CloseGUI() _GUICtrlListView_UnRegisterSortCallBack($hListView) GUIDelete() Exit EndFunc ;==>CloseGUI

May I ask how to create a binary gif in your example?