Opening a file with a Wildcard

[ADP_MAN]

**Note: I think I posted this in an incorrect forum before so I'm posting it here again. Sorry for the double post**

I have a file that needs to be opened and renamed on a daily basis. PART of the filename changes daily so I want to open the file using the "*". Here is part of the script I have so far:


I first want to locate the file and see if the file is there. In this case the file name is "ETCTXT02292295P.091008.024310001.txt" The first part of the file name does not change "ETCTXT02292295P." and the second part is the date. The final part of the file name changes daily and it's not something I can determine. When I run IfFileExists using the formula below, it will correctly tell me if the file exists or not. After that is complete I want to open the file and that is where I'm having problems. Any suggestions?

Day>theDay
Month>theMonth
Year>theYear
//GET LAST TWO DIGITS OF YEAR
MidStr>theYear,3,2,theYear

//DETERMINE YEAR
ifFileExists>T:\IQ\DATA\COMM\outbound\outbound\ETCTXT02292295P.%theMonth%%theDay%%theYear%*,Open

Label>Open
ExecuteFile>T:\IQ\DATA\COMM\outbound\outbound\ETCTXT02292295P.%theMonth%%theDay%08*

Thanks in advance,
Dominic

[Marcus Tettmar]

Use GetFileList. See my reply to your duplicate post.