I've spent the hour reading through several post pertaining to using wildcards in standard IF statements.

Didn't find anything useful. May be I'm not getting the concept yet. I'm in my second full day of using this application, so a little slack is appreciated.

I have a file I need to download each day. It is in the format Filename_20110325071039.csv (yyyyddmmhhmmss). There is nothing I can do about the name. There is no way to anticipate the hhmmss, obviously, so I included ?????? in the variable that builds the filename.

No bueno.

The IF statement finds itself in a LOOP. The LOOP looks at a long file list of the FTP directory contents. I see the file go by when running in debug mode. So I know the file is there. I also see the variable displayed as Filename_20110325??????.csv.

So, basically the IF statement looks like something like this:
   If %variable1% = %fileList.fileName% then...

Category Survey

Bill,
unfortunately, IF's do not accept wildcards.
You would have to do a complex IF for instance
IF %left(variable1,17)=left(filelist.filename,17) AND right(filelist.filename,4)=".csv"%

Category Survey AutoMate 7 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

Bill,
I answered too fast.
A possibility exists using the "like" operator in the expression in the IF
IF %filelist.filename LIKE variable1% then

The LIKE compares with wildcards in the second term

Category Survey AutoMate 7 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

OK, here is what I did:

If ((StrComp(strFilename, Left(fileList.FTPFileName, 21), 1) = 0) AND (bolSuccess <> 1))

I know what the first 21 characters of the file to download will be each day. The hhmmss would be a shot in the dark.

So, by grabbing each file in the FTP list and performing a string comparison on the first 21 characters, the file is located and downloaded.

Thanks for the direction.

 

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMIF EXPRESSION="%(StrComp(strFileName3, Left(fileList.FTPFileName, 21), 1) = 0) AND (bolSuccessSQFile &lt;&gt; 1)%">

You're welcome, Bill.
Your solution with StrComp is also quite nice.

Category Survey AutoMate 7 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

Very useful thread - helped me out of a jam today.   Thanks Jean and Bill.

Category Survey