Edit file name

[putmann]

I have a file name where there is random 6 digit number generated daily within text of the file name. I want to copy the file name to a different name, but wildcards won't work because of the random generated number in the file name.

copyfile>T:\DailyDataFiles\ProcessedFiles\LIJ_IP_DAILY_AR_PROCESSED_052005_FIXLENGTH.TXT,\\nasdata02\finance01\DATA\SMS_MC\Projects\_Databases\Archive\C\Cash\Daily CashDB Backup and Test\CashIP.TXT

[Bob Hansen]

I think that using VB Script RegEx will work for you.

You could use a RegEx to capture something like this:
"T:\DailyDataFiles\ProcessedFiles\LIJ_IP_DAILY_AR_PROCESSED_[0-9]{6}_FIXLENGTH.TXT" and assign it to a variable to be renamed.

[putmann]

Bob, Thanks