Replace with CSV tags not working

Advanced Renamer forum
#1 : 20/03-19 15:09
Benjamin
Benjamin
Posts: 2
Hey everyone,

So I'm having trouble getting the Replace function working properly when I'm importing Data from CSV files. I have a list that looks something like this:

Old New
1240539001 1002172001
1240539400 1004655400
1242755001 1004705001
1242755090 1004706090
1242755100 1004707100

And filenames that look like this:
1240539001_1.jpg
1240539001_2.jpg and so on.

Using <Csv:1> for "Text to be replaced" and <Csv:2> for "Replace with" I should get the result:
1240539001_1.jpg > 1002172001_1.jpg
1240539001_2.jpg > 1002172001_2.jpg

But I get nothing, it doesn't recognize the data from <Csv:1>. If I change that one to say the number 1 it fills in everything from <Csv:2>, completetly random obviously as the number 1 pop ups everywhere. I figured it was my files but when I import the data I can see the lists with all the data. Isn't this what the CSV import was made for or have I misunderstood the feature?

I thought I could paste lists in List Replace instead but I seem to have to paste in one string at a time instead of the entire list. Other than these two issues the application is great!


20/03-19 15:09
#2 : 20/03-19 18:10
David Lee
David Lee
Posts: 1125
You appear to have misunderstood the purpose of CSV import. It's explained in the User Guide at www.advancedrenamer.com/user_guide/csvdataimport

Basically tags from each line of the file (<Csv:1>, <Csv:2> etc) represent metadata to be included in the files in the corresponding position in the List.

List replace is the method you need to use and it's unfortunate that Kim hasn't yet enabled import/export of data to/from this list.


20/03-19 18:10
#3 : 21/03-19 11:05
Benjamin
Benjamin
Posts: 2
Reply to #2:
Hi David,

Thank you for your reply! Okay shame it wasn't what I thought but at least I won't be going mad now :)

Was able to sort it out with a ren scriptso it's good. Importing a list in the List Replace would definitely be something for a future update I think.

Here's the script if anyone needs a similar thing:

ren 1240539001*.* 1002172001*.*
and so on.

Easy to sort out if you already have the list with what you want to replace.

Thanks again David!


21/03-19 11:05