Rename 3000 files with names from data tables

[JamesC]

Hi,

Complete newbie - a few days into my UI path journey. I have basically no programming abilities, though i understand a few of the concepts.

I have 3000 files in a folder - i want to rename them.
through watching some tutorials i’m confident i can can get every file name and load into a new data table.

e.g. file names - three file types for each code:
123456789.csv
123456789.xml
123456789.html

Each file starts with an 8 or 9 digit string eg "123456789. That string exists in an existing data table.

The each row in the data table has the 8-9 digit string and a corresponding name e.g. “123456789”, “Smith, John”

I want to rename each file from say “123456789.csv” to “Smith John.csv”. So i think i need to split the name into two columns in the data table. Then use the code to look up those two names, then do the file rename.

Any pointers?

Thanks a bunch!
James

[Yoichi]

HI,

In this case, I reccomend to use Dictionary as the following sample.
(This sample changes filename in “test” folder)

Sample20221107-1.zip (4.6 KB)

Hope this helps you.

Regards,

[JamesC]

Hi Yoichi,

Thank you so much for taking the time to respond.

That is amazing and I have gotten it to work.

You are excellent!
Thanks again.
James