find file from a folder with highest revison--resolved

[var]

Helloo all
I have hundreadd of files in a folder and and what to get file name with highest revison number

eg

folder name: c:\reports

CA08374-00-kevin files.xls
CA08374-01-peter files budget .xls
CA08374-02-cindy returns.xls
CA08374-03-mary report from last month.xls

so here i want to get file name of "CA08374-03-mary report.xls"


thanks for help

regards

[fredlo2010]

Hello,

Maybe something like this

Please Login or Register  to view this content.

Hope it helps

[var]

thanks fredlo,

that is working great.
could explain a bit of how code works in this case..

looks simple and an when I try to understand I get confused.

[fredlo2010]

Hi var,

I am sorry I took so long to reply; I am been kinda busy today.

I have commented the code more. I hope it makes thing clearer for you. Basically the code is saying: Give me all the files that match a specific pattern; along the away always hold a value (ret). Compare the latest file you got with the one you are holding; if the new one is greater than the one you are holding then drop it and hold the new one.

Please Login or Register  to view this content.

Hope this helps