Is there a way to rename a file using wildcards in the Rename variable - like the below:
{STRING(Replace|{NEWNAME()}|ARTB_SA_#####_#####.csv|Dereg_#####_#####_{DATEFORMAT(yyyy-MM-dd-HHmm)}.csv)} or
{STRING(Replace|{NEWNAME()}|ARTB_SA_*_*.csv|Dereg_*_*_{DATEFORMAT(yyyy-MM-dd-HHmm)}.csv)}
Where # represents a numerical digit which could be any number configuration assigned by source system. I have tried this and it fails.
I've even looked at Task variables, which might work, but the variable holds the .csv extenstion, so I'm not sure how to append date stamp in that situation.
Any feedback appreciated.