How to Read .txt File Content and Use _DateDiff

[alanbr00]

I'm trying to make more easy to identify lines of a txt.

Imagine a txt file with this content:

2021/01/01

2021/02/02

2022/02/02

I wanna see only those first two lines that are old.

Solution:

get-content "C:\school\result.txt" | where { [datetime]($_.split(','))[0] -lt (get-date).date.adddays(-30)}

 

Edited February 13, 2022 by alanbr00

[Gianni]

? do you mean in AutoIt or in PowerShell?
Here a possible way in AutoIt

; #include <array.au3> ; if you want to use _array  functions

; read the file in a string
$string = FileRead("result.txt")

; clean the string from extra unwanted "WhiteSpaces"
$string = StringStripWS($string, 7) ; 7 ->  see help

; split dates into an array
$array = StringSplit($string, @CR, 2) ; 2 -> $STR_NOCOUNT

; Sort the array if needed ...
; _ArraySort($array)

ConsoleWrite($array[0] & @CRLF) ; print first date
ConsoleWrite($array[1] & @CRLF) ; print second date

 

[ad777]

@alanbr00

how to use _DateDiff:https://www.autoitscript.com/autoit3/docs/libfunctions/_DateDiff.htm

how to read first two line's:https://www.autoitscript.com/autoit3/docs/functions/FileReadLine.htm