#1 2023-09-23 04:12

koolestani
Member
Registered: 2020-04-26
Posts: 9

Search for given filenames and Replace them with new given filenames

Kind of like User Input section, but with two columns.

In Column A, I want to input filenames that I want to be replaced.
In Column B, I want to input their new filenames.

Is there something similar in ReNamer already or some other way to achieve this?

I basically want to drag and drop say 100 files into ReNamer. I have a list of old filenames and new filenames for 20 files.
I use the above method, and ReNamer does the renaming for the 20 files out of the 100 and the remaining filenames stay untouched.
This helps me save time on manually searching for the 20 files and then bringing them into ReNamer.

The Replace section of the toolset can technically do this, but it needs multiple items to be separated by a pipe symbol, while I have a list where the names are separated by a line break. So I'd have to spend considerable time on reformatting them for ReNamer.

Last edited by koolestani (2023-09-23 04:17)

Offline

#2 2023-09-23 10:49

Stefan
Moderator
From: Germany, EU
Registered: 2007-10-23
Posts: 1,161

Re: Search for given filenames and Replace them with new given filenames

For an example see "Rename multiple files using a txt file?" >>> https://www.den4b.com/forum/viewtopic.php?id=2867




Do that work for you?

(be sure to have an backup, as always)
 


Read the  *WIKI* for HELP + MANUAL + Tips&Tricks.
If ReNamer had helped you, please *DONATE* to Denis or buy a PRO license. (Read *Lite vs Pro*)

Offline

#3 2023-09-23 16:30

koolestani
Member
Registered: 2020-04-26
Posts: 9

Re: Search for given filenames and Replace them with new given filenames

When I try to rename using the Import file paths and new names option from the Export menu using a .csv file, I get this error.
Error

Last edited by koolestani (2023-09-23 16:32)

Offline

#4 2023-09-23 17:13

Stefan
Moderator
From: Germany, EU
Registered: 2007-10-23
Posts: 1,161

Re: Search for given filenames and Replace them with new given filenames

What it says.



Maybe post your csv list so we can point you in the right direction.




 


Read the  *WIKI* for HELP + MANUAL + Tips&Tricks.
If ReNamer had helped you, please *DONATE* to Denis or buy a PRO license. (Read *Lite vs Pro*)

Offline

#5 2023-09-23 21:46

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,388

Re: Search for given filenames and Replace them with new given filenames

You might be missing the path component when importing files.

Which version of ReNamer are you using?

Recent versions have a few important improvements related to the import feature, for example:

7.3.0.3 Beta:
  Resolve relative paths when importing file paths and new names from a file.
  Handle errors when creating target directories during a renaming operation.
7.1.0.2 Beta:
  Use RFC 4180 compliant CSV handler for importing/exporting files. Improved handling of unquoted values.
  Handle errors gracefully when importing files.

Offline

#6 2023-09-24 00:21

koolestani
Member
Registered: 2020-04-26
Posts: 9

Re: Search for given filenames and Replace them with new given filenames

Yep, that was it. Updated to 7.5 and it worked like a charm. One last question, right now I have to maintain two .csv files.
One that has "old names" in Column A & "new names" in Column B (I'll use this one to bulk rename from old to new names)
One that has "new names" in Column A & "old names" in Column B (I'll use this one to bulk rename from new to old names)

Is there someway to achieve both with a single .csv file?

I mean it's the same data in the just the columns have been swapped.
Can ReNamer be instructed to use the data from the columns in a left to right direction? That way just one .csv will do both the jobs.

Last edited by koolestani (2023-09-24 00:32)

Offline

#7 2023-09-27 00:54

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,388

Re: Search for given filenames and Replace them with new given filenames

koolestani wrote:

Is there someway to achieve both with a single .csv file?

You could store the master list in a spreadsheet file (LibreOffice Calc, MS Excel), where you can easily swap the columns around and export as CSV files on demand.

Offline

#8 2023-09-27 01:20

koolestani
Member
Registered: 2020-04-26
Posts: 9

Re: Search for given filenames and Replace them with new given filenames

Ok, yeah that seems better than maintaining two .csv files. Thank you smile

Offline

#9 2024-04-03 16:31

tdsra
Member
Registered: 2024-04-03
Posts: 2

Re: Search for given filenames and Replace them with new given filenames

This is an old thread but I'm a new user to renamer and I have the same question as the OP.  However my version is 4.65 (my firm uses a very old version) and I don't see an Export option.  Is there another way to change a list of files based on a spreadsheet or textfile I've created with the old / new names?

Offline

#10 2024-04-03 23:29

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,388

Re: Search for given filenames and Replace them with new given filenames

tdsra wrote:

This is an old thread but I'm a new user to renamer and I have the same question as the OP.  However my version is 4.65 (my firm uses a very old version) and I don't see an Export option.  Is there another way to change a list of files based on a spreadsheet or textfile I've created with the old / new names?

Version 4.65 does have some import and export options. You can find them in the Options menu above file table.

However, that version is almost 17 years old, so I would strongly recommend you to upgrade to the latest version.

Offline

Board footer

Powered by FluxBB