I have 500 files I need to rename. currently the files are named by Client ID.SubID but I need them to be named by company names.
I have a CSV file that has the ClientID.SubID (ie., Company.001) and list the company name next to it (ABC Company). I have 500 files in explorer that I want to check against the csv file, find the correct client Id and rename the file with the corresponding file name. Can this be done in uipath? if so HOW?
I have tried the Move file activity but I am not sure on how to get my output name from the Csv file to be copied and then pasted as the new file name. i have seen a lot of post on how to rename and trim or manipulate a current file name but how can I cut and paste a name from a n excel spreadsheet or scraped date to make it the new file name?
Please anyone HELP