Rename from list

Advanced Renamer forum
#1 : 26/07-19 10:55
Dan
Dan
Posts: 2
Hi
I have a text list that have a few codes and names, they aren't like each other but each name has own code
Example: (PS: 3416 is code of piano)
(test file):

Piano
3416
Plastic
3444
John
3443

Other side i have a few files that they names are codes
I want rename the code files
How can i do that?

Example:

3416
3444
3443


26/07-19 10:55 - edited 26/07-19 11:07
#2 : 26/07-19 14:50
David Lee
David Lee
Posts: 245
Your question is unclear. Please give us specific examples of filenames before and after renaming.


26/07-19 14:50
#3 : 26/07-19 17:28
Dan
Dan
Posts: 2
Reply to #2:
This is my text list :
TR.Uc.Harfliler.Beddua.2018
2228.mp4
TR.Trilece.2018
2227.mp4
TR.Babamin.Ceketi.2018
2226.mp4
TR,Bucur.2018
2225.mp4

these are my file :
2228.mp4
2227.mp4
2226.mp4
2225.mp4

in fact i should search 2228.mp4 in my text list after find it i should copy upper name of the 2228.mp4 (TR.Uc.Harfliler.Beddua.2018) and put it instead of 2228.mp4
it means it will be TR.Uc.Harfliler.Beddua.2018.mp4


26/07-19 17:28
#4 : 26/07-19 18:01
David Lee
David Lee
Posts: 245
Reply to #3:
You need to use "Import -> Files from CSV..."

See www.advancedrenamer.com/user_guide/csvimport

Order your table as a csv file with exisiting filenames (including extensions) in column 1 and new names in column 2...

2228.txt,TR.Uc.Harfliler.Beddua.2018
2227.txt,TR.Trilece.2018
2226.txt,TR.Babamin.Ceketi.2018
2225.txt,TR.Bucur.2018

If your filenames can contain commas (ie if the comma in your 4th example is not a mistake) then you can choose any separator you wish (see below).

Run "Files from CSV..." from the Import menu and follow instructions in the dialogue. Your files will be loaded and the List method will be populated automatically.

_______________________________________________________________________________
Changing csv file separator:

If you are using Excel to generate your text file it is possible to change the separator in a "csv" file from a comma to any other character.

Excel uses the default list separator defined by Windows and you can change it from Windows Control Panel -> "Region and Language". From the Formats tab select "Additional settings" (or Customize on the Regional Options tab if you are still using XP). Simply change the "List separator" as required and apply. This separator will then be used by Excel - and any other application that takes its default from Windows.


26/07-19 18:01 - edited 27/07-19 19:34