Selecting files with current date in file name in WinSCP and PowerShell

Question

I am new to WinSCP and PowerShell.
I am trying to look for files in a directory that has the pattern "ABC"+somenumbers+YYYYMMDD+somenumbers.zip

$dt = (Get-Date).ToString('yyyyMMdd') 
$transferOptions.FileMask = ("ABC*>=" "+$dt+".zip")

I am not able to get any files downloaded to local directory. Is my file mask correct?

Thanks
MR

Would you confirm that that is actually what you have for the filemask, as it looks to me as if there is a typo. Also, the > syntax appears to be for the file modified time, not something you can use within the filename portion. — Andrew Morton
– Andrew Morton, Commented Jul 31, 2018 at 16:52
The file name has today's date with format YYYYMMDD. I didn't know >= is only for modified dates — user2726975
– user2726975, Commented Jul 31, 2018 at 17:00
I suspect you want $transferOptions.FileMask = "ABC*$dt.zip". — Andrew Morton
– Andrew Morton, Commented Jul 31, 2018 at 17:08
@MartinPrikryl I think I missed the second "*", but I put it in the answer. — Andrew Morton
– Andrew Morton, Commented Aug 1, 2018 at 9:55

Andrew Morton · Accepted Answer · 2018-08-01 09:51:56Z

1

As the date is part of the filename, you don't need to use the ">" syntax in the filemask, which would be for the file modified time.

Powershell will expand variables inside double-quoted strings (Variable expansion in strings and here-strings), so you can use

$transferOptions.FileMask = "ABC*$dt*.zip"

answered Aug 1, 2018 at 9:51

Andrew Morton

25.3k9 gold badges66 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1