SFTP Filename with Rnadom Number
I'm having an issue where the Excel filename provided to us in a SFTP repository contains a random 9 digit number. Is there a way to include a wildcard character or possibly regex in the filename? Example: Company_Daily_Extract_667819222.xlsx I have tried various methods when setting the Remote Filename:…
