#1 : 02/07-15 02:33
I have a lot of files that I am renaming and putting into new folders.
Examples of file names:
PARKER, MILLER M_092844_229084540_PA Form_Fax Back Missing ICD
RECON_PARKER, MILLER M_092844_clm #1508433006_ET notes
RX_PARKER, MILLER M_092844_227837782_PA Form no pa
I use the methods:
New case: Set lower case
New case: Set upper case first letter in every word
To get the file names to be in the format of the first file name
The current file path I am using is:
P:\Health Care Services Files\~~Working Files\Jade\HCS Member Files Dummy\<substr:1:_>_<substr:_:_>
This does great for the first two file names and puts them in:
P:\Health Care Services Files\~~Working Files\Jade\HCS Files Dummy\Purdo, Beth_021578
P:\Health Care Services Files\~~Working Files\Jade\HCS Files Dummy\PARKER, MILLER M_092844
However, the third and fourth file I would really like it to ignore the prefix of RECON_ or RX_ and just put it in the same folder as #2 (P:\Health Care Services Files\~~Working Files\Jade\HCS Files Dummy\PARKER, MILLER M_092844)
Is there a way to do this?
Also, right now if I want the folder to be made using the same case as the file like Purdo, Beth_021578, instead of all caps, I have to run the renaming first then move them seperately. Is there a way to get it to use the new file name instead so it can be done in one swoop?