I have to read folder names from excel file and using for each loop have to create folder in web application however the problem i m facing is how to let BOT read each item from the excel cell separated by “/” or " " and use unique name create folder in web application.
I have tried using row(“FolderName”).ToString.Split(CChar(“/”)) in For each Loop but it is not working
Use If condition
If row(“FolderName”).ToString.contains(“/”)
Then
FolderArray=row(“FolderName”).ToString.Split("/"c)
It will be create an array
so say For Folder1/Folder2 : It will give u
FolderArray(0)-Folder1
FolderArray(1)-Folder2