Rename or create new files on windows

rpaexpress
files-and-folders

#1

Please provide me a solution or workaround for handle this scenario related to Folders.

  • There are file location in a example.

%USERPROFILE%\Documents\ebank_se1\Local\201701
%USERPROFILE%\Documents\ebank_se2\Foreign\201701

  • There are around 50 file location with ebank_se1 to ebank_se50.
  • Last file is “201701” this is change each and every month, in example
    2017 January - File name has to be 201701
    on 2017 Feb -File name have to rename t0 201702 … etc
    – So how to Handel and implement this script using RPA express ???

#2

I was searching for something related to date formatting but looks like there is no feature that allows you to manipulate date values as strings as of now.

See this
https://forum.workfusion.com/t/date-operations-in-workfusion/3428/8


#3

I developed a Excel Macro :smiley:


#4

Cool… would you mind sharing it . will be a temporary solution to everyone.


#5

Sure Bro,
This the excel macro that I wrote,
File Rename.rar (23.8 KB)


#6

thank you… your idea of using excel has opened up a new way to solve many such limitations.

My requirement was to get the date in DD-MMM-YYYY format. and I did it like this.

  1. Launch Excel
  2. Enter text =Today()
  3. Move right, enter formula
    =TEXT(A1, “dd-mmm-yyyy”) that formats the value
  4. copy to variable.