Look up current filename in a text file and append associated text

andycoach · 2019-07-16 03:32

My apologies if this has been covered, I looked through the interface and did a basic search on this forum but perhaps I am not searching right.

Is there a way for a mere mortal (not a programmer) to upload a text lookup file, where in the 1st column we have the current names of the files to be affected and next to each filename, we have some extra text that we would like to append to the filename.

For example, our filenames have the FIPS state code in the name but we want to add the explicit state name to the file name.

lookup text file:

filename, state_name
2010_ver1_02.zip, Alaska
...

So we want the resulting file name to be like so

2010_ver1_02_Alaska.zip

Is this possible in ReNamer?

Stefan · 2019-07-16 08:26

Hi and welcome.

You could try if you could utilize the "Translit" rule:
http://www.den4b.com/wiki/ReNamer:Rules:Translit

C:\TOOLs\ReNamer\Translits\TESTuscode.txt

TESTuscode.txt content:
_02=_02_Alaska
_03=_03_Somewhere
_04=...

HTH?

den4b Forum

#1 2019-07-16 03:32

Look up current filename in a text file and append associated text

#2 2019-07-16 08:26

Re: Look up current filename in a text file and append associated text

Board footer