I have three txt files A, B, and C in a folder … each file has a different Date/ time inside. I need to pickup that from txt file and then compare with each files, if the date/time is latest, I will keep that file, rest I will either ignore or delete.
if A has date/time 10 oct 2020 11:45 , B has 10 oct 2020 11:50 and C has 12 oct 2020 1:00 inside txt file
So bot should pick option C and also its occuring alot of times in Txt, shall we use Regex? or do data table manipulation or else. Please give correct approach.