Creating Folder based on Surname Name

This is my first automation project, and I am stuck it the process of creating a folder in a location, the location has folders named (A-D, E-H, I-L…), I want to create a sub folder based on the first letter of the surname for the employee.

So for someone with surname “Darling” a folder should be created within the folder named “A-D”

1 Like

Hey @Johnson_Jacob

You can just use Create Folder activity.

For picking the first letter, Just do the str_Surname(0).ToString.ToUpper

Hope this helps.


Hi @Johnson_Jacob ,

Could you give this sequence a try?

CreateFolderBasedonLetters.xaml (13.8 KB)

Kind Regards,
Ashwin A.K