Something strange with New path from Csv

Hello,
I am experiencing a strange issue with the latest version of Advanced Renamer when copying and moving files.
When I drag and drop files into the program's window, I export the list to a CSV file and then use Microsoft Excel to change the paths. After importing the CSV file, I try to use the path in the <Csv:8> field, but instead of completely replacing the old path with the new one, the new path is added after it. Also all the \ in the new path are replaced to -
Why is it happening?

https://imgur.com/a/PEuSzuZ

Reply to #1:

Hi Arthur,

I can't speak to why that's happening, but I can tell you that in fiddling with this problem I found something interesting. I used the "Save list / To CSV file" (NOT "To text file") in the right-click menu over the file list, then saved the .csv file with a ".txt" extension instead, and everything worked as expected (?). I have no idea why, but give it a try and see if it works for you.

If you save the file with the "New Path" column showing, and modify that column, you don't even have to use the <csv> tag.

I'm sure Kim will correct the problem at some point, but in the meantime this workaround should help.

Best,
DF

Reply to #2:
"If you save the file with the "New Path" column showing, and modify that column, you don't even have to use the <csv> tag."

Thank you for your answer! What do you mean by that? I use AdvRenamer like this:
1. Drag and drop files or folders into the program.
2. Save the list to a CSV file.
3. Open it in Excel and change some columns, for example, the File Path in column 3
4. Save and close the CSV.
5. Import - Data from CSV in AdvRenamer.
6. Choose the CSV file.
7. Use the Move or Copy options with the <Csv:3> column in the Output folder field.
Is there anything wrong with this way of using AdvRenamer, or is there an easier way to do it?

Reply to #3:

Arthur,

There's nothing wrong with how you are using it. What I suggested is just another way of letting the program know what you want done.

If you right-click on the column header (File Name, New Name, Error, Path, Date Created, etc etc) you can add the "New Path" column to your layout. If you do that you'll have a new column, "New Path", saved when you save your .csv (or .txt at the moment I guess). :)

Now, if you modify the "New Path" column in your spreadsheet instead of the "Path" column, when you put it back in ARen the program will just know that you have new locations for (some?) files. It's like using the "item.newPath" statement in a script method - once you change that internal variable the program just "knows" that's where you want the file moved or copied to.

I'm not sure it's better than the way you are doing it; it's just another way to do it. Hopefully Kim will at some point add the ability to save column layouts in version 4, then it *would* be more efficient to use this method. As it is now you can't count on the "New Path" column being where you left it...

Harosheva dnya,
DF