#1 : 10/03-25 07:41 Mariya
Posts: 1
|
Hello everyone,
I am seeking some help regarding file names from an csv file in excel. for example I have a few files like below which needs to be renamed from the excel file. 001 - 01 January 2025 002 - 02 January 2025 003 - 03 January 2025 The data I have in excel is : Column A Column B 001 Monday 002 Tuesday 003 Wednesday What I need is the new file name should be as : 001 - 01 January 2025 - Monday 002 - 02 January 2025 - Tuesday 003 - 03 January 2025 - Wednesday Is this possible please and if you know how to do it I would appreciate it heaps. Many thanks for reading my post and looking for some assistance. |
#2 : 10/03-25 10:11 Styb
Posts: 156
|
Reply to #1:
Hi, it's possible. Once you have added your files, import data from CSV via the Import menu, you will see the column number 1 and number 2, press the Import button. At this point you need the column number 2. Open the Add method and set it like this: Add: - <Csv:2> At index: 0 Backwards checked Apply to: Name See the image: https://postimg.cc/LY6Q6F3b Run the batch to get your new file names. Good luck! |