telmob

Find latest in text file

7 posts in this topic

I have several (1000+) text files in the directory test\ with contents like the following:

text1
20/01/2016  text
text1

The date is always on the same line.

I need to find, in all the files, the one that has the newest date. I know i need to change the date format, that is no problem, i can change it. But i have no idea in how to find the newest date. Is there a function reference that can do that?

Share this post


Link to post
Share on other sites



telmob,

Just as we did in your last thread, use _DateDiff on each file checking to see if this file is earlier than the earliest one we have found so far.

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

Maybe a faster way than using _DateDiff : format the dates "20/01/2016" to numbers "20160120" and then look for the highest one ?

Share this post


Link to post
Share on other sites

Thank you both. I was wondering how i could find the highest (date) value without having something to compare with (like i did in my previous post).

You guys rock! Time to put my brains to work.

Share this post


Link to post
Share on other sites

Ok, i know i'm doing something wrong here:

For $i = 1 To $aFiles[0]
    $aLines = FileReadToArray($aFiles[$i])
    $sDate = StringLeft($aLines[5], 10) ; Note element 5 = line 6 because array is 0-based
    $new = StringRegExpReplace($sDate, "\A(\d*)/(\d*)/(\d*)","$3$2$1"); converts date to number format (20170210 for ex.)
    $iDateCalc = _DateDiff('D', $new, $new_new)
    $sLastDate = $iDateCalc < "0"
    $sFileNameTrim1 = StringRegExpReplace($aFiles[$i], "^.*\\|\.txt", "")
    ; Add data to ListView
    If $iDateCalc <> "0" Then GUICtrlCreateListViewItem($sFileNameTrim1, $Diferenca)
Next

_ArrayDisplay($new);not displaying anything. Not an array?
msgbox("","",_ArrayMax($new, 1, 1));nope.

I'm going nuts...

Share this post


Link to post
Share on other sites

Sure. You don't compare the same things any more. The code must be adapted to number comparison  :)

Local $highest, $myfile = $aFiles[1]

For $i = 1 To $aFiles[0]
    $aLines = FileReadToArray($aFiles[$i])
    $sDate = StringLeft($aLines[5], 10) ; Note element 5 = line 6 because array is 0-based
    $new = StringRegExpReplace($sDate, "\A(\d*)/(\d*)/(\d*)","$3$2$1"); converts date to number format (20170210 for ex.)
    If $new > $highest Then 
         $highest = $new
         $myfile = $aFiles[$i]
    EndIf
Next
msgbox(0,"", $myfile & " (" & $highest & ")" )

 

Share this post


Link to post
Share on other sites

LOL! And i was looking for something more complicated....

Thank you so much Mikell!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now