Newbie here. Using StreamReader in VB, I am trying to read any csv file. Filename changes daily as it contains current date. Trying different Regular expressions to represent filename but with no luck.
My original line -
objReader = New IO.StreamReader("\\FolderA\FolderB\SEBCTS20220831.csv")
I have tried -
objReader = New IO.StreamReader("\\FolderA\FolderB\^SEBCTS\w\w\w\w\w\w\w\w\.csv$")
objReader = New IO.StreamReader("\\FolderA\FolderB\^\w\w\w\w\w\w\w\w\w\w\w\w\w\w\.csv$")
But I got error - Error: Could not find a part of the path '\FolderA\FolderB^SEBCTS\w\w\w\w\w\w\w\w.csv$'.
I also tried -
objReader = New IO.StreamReader("\\FolderA\FolderB\^SEBCTS[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9].csv$")
I get the error - Error: Could not find file '\FolderA\FolderB^SEBCTS[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9].csv$'.
Can somebody point me in the right direction? Any help will be appreciated.