Renaming multiple files inside one Folder

[heinzawhtooaung (Hein Zaw)]

Hello RPA Experts,

I would like to rename 3 files inside one folder as shown in picture.

Number one file is “History Performance_GSM_CSPS Traffic_CA_Dashboard KPI_YYYYMMDDHHMMSS”. I would like to rename that file to “History Performance_GSM_CSPS Traffic_CA_Dashboard KPI”. I mean , I just want to delete tail of file name. I just want to remove YYYYMMDDHHMMSS.

Number two file is “History Performance_LTE_PS Traffic_CA_Dashboard KPI_YYYYMMDDHHMMSS”. I would like to rename that file to “History Performance_LTE_PS Traffic_CA_Dashboard KPI”. I mean , I just want to delete tail of file name. I just want to remove YYYYMMDDHHMMSS.

Number three file is “History Performance_UMTS_CSPS Traffic_CA_Dashboard KPI_YYYYMMDDHHMMSS”. I also just want to delete tail of file name. I just want to remove YYYYMMDDHHMMSS.

These YYYYMMDDHHMMSS are varies. Not Fixed. It is changing every time export from system.

All these three files are located inside one folder. Thank you so much in advance.
(Inside that forum I found to rename word files. I also tried that one. But I can’t find “system.String” variable in my Uipath studio).

[Pratik_Wavhal]

Hi @heinzawhtooaung

You can Extract the Name by eleminating the further details using Regex and String Manipulation as shown below :-

regex101: build, test, and debug regex

Regex :-

.+(?=_\d{14})

String Manipulation :-

item.ToString.Substring(0,(item.ToString.IndexOf(item.ToString.Split("_"c)((item.ToString.Length-item.ToString.Replace("_","").Length)-1)))-1)

Below is the workflow for the same :-
MainPratik.xaml (9.3 KB)

Output :-

To Rename you can use Rename File Activity :-

Download the below package for the same :-

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal