Hello, i have a list of files from an FTP server that I have read into a List. The last field in the list is the file name. The file name generally follows this format: "ProjectInfo_YYYYMMDD". YYYY is the four digit year, MM is the 2 digit month, and DD is the 2 digit day. I want to choose the one that matches today's date. I'm guessing this can be accomplished with the use of a user param or regular expression but I can't seem to find a reference on it. Any assistance would be appreciated.
Page 1 / 1
One way to accomplish with a single Tester or TestFilter:
Set the left value to:
@Substring(@Value(file_name),-8,8)Set the right value to
@DateTimeFormat(@DateTimeNow(),%Y%m%d)