Rename File based on the first 5 character of excel

Rename File based on the first 5 character of excel. Mapping file available at location C:// Revenue Files.

Append 3 characters in the existing file name.

Eg. File name is VMA01_2019-08-27, The new files will be MAN_VMA01_2019-08-27 (See mapping file)Assessment (3).zip (59.7 KB)

Hi, hope this helps:

Main.xaml (7.8 KB)

Reference:


please see the zip file, first we have to match with mapping file then replace the csv
image
we have to match file name and replace with prefix than rename the file