I'm trying to use BRU and regular expressions to achieve filenames that have to be in a very specific format.
File format is:
24 characters long
First 6 are constant
Next 8 are date in YYYYMMDD format
Next 1 constant
Next 2 file index numbers from 00-99
Last 7 constant.
Initially the files arrive in somewhat varying formats, but I've been able to capture all of that by using:
Match: ^([A-Z][a-z]*)
The replace statement is where I'm having trouble. The first 6 digit constant is simple enough, but moving on to include the formatted date and next constant are where I'm having trouble.
Right now I can get the right final file name, but I've literally had to resort to only using replace for that first 6 digit constant, then using the Custom Auto Date with the next constant included in it, Numbering starting at character 15 to handle the index numbers, and the last 7 constant by naming my folder that and using the Append Folder Name option as a suffix.
In other words, I'm a total rookie, have devised a very ugly method of achieving what I need, but would much prefer something more appropriate, cleaner.