antp.be forum

Hello,
I'm trying to use the multiple string replacement function to operate as a sort of "vlookup" plus "find and replace." I have several thousand PDF files that are named with a client's file number and I want to replace those with our firm's file number. I have an excel spreadsheet with all the file numbers matched up and I want to import that data into the multiple string replacement grid without having to type all 5,000 file numbers into the program. Is that possible?

Hi,
I should have included an import/export for that grid...
But you can easily go add it into the prefs.xml file.
Create a new set with one or two values just to have it appear in the file, then open that file in a text editor (notepad, ...)
You should find your set in it, with a CDATA section. In that section pairs of values are separated by a tab, meaning that if you copy the two columns from Excel and paste them there it should be fine.

Thank you for your quick reply! Unfortunately, my programming skills are high novice, at best. Can you explain how to access this "prefs.xml" file?

There is no programming here
That file should be in the program's installation folder (c:\program files\ant renamer, or something like that).
However, if you have Windows Vista/7/8 with UAC enabled you'll not find it there. In that case, type %LocalAppData% in the address bar of Windows file explorer, there you'll find a "VirtualStore" folder, under which you can find program files\ant renamer.
There is a prefs.xml file there, you can open it with Notepad or another text editor.

Hi,

For anyone like me who's looking for the same thing in 2020 or later, know that the location of the preference file has changed since v2.11.
The file is now named Renamer.xml and ends up in C:\ProgramData\Ant Renamer