#1 : 26/07-19 10:55 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 |
#2 : 26/07-19 14:50 David Lee
Posts: 1125
|
Your question is unclear. Please give us specific examples of filenames before and after renaming.
|
#3 : 26/07-19 17:28 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 |
#4 : 26/07-19 18:01 David Lee
Posts: 1125
|
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. |