Excel Use Case 1 Solution - UiPath

[@vishalshukla1028]

Thanks Rakesh! In many of case you have life saviour for me while Development. Keep posting new video i really learn alot of trick and tip from you. Heartly Thanks!

[@AutomatewithRakesh]

You are most welcome Vishal it’s nice to realise how it is helping everyoneContinue your learning journey and keep commenting it feels good

[@crazyvenky1258]

Thank you for your continuous knowledgeable videos, I have practiced the usecase. Keep smiling 😁.

[@RajKumar-ck3qu]

Awesome trick, was thinking how we can split strings of different length…Wonderful tip and time saviour as always from you…Please do share us such wonderful tricks..

[@sandeepreddy4093]

Hi Rakesh, Thanks for letting us know this particular use of Split function previously I have only used single delimeter split or to get value between two delimeters. Thanks

[@AutomatewithRakesh]

Most welcome

[@arsavarthiniamu2242]

If there are mutiple delimeters then we have to assign all from excel sir

[@AutomatewithRakesh]

Yes based on requirements

[@vinayawasthi9241]

Hello Rakesh Sir....big fan and a subscriber of yours.... Sir I have one doubt that if you could create a video of a workflow using reframework where for every business or system exception, the exception is moved to the end process state through the out arguments and an exception mail is triggered based on the kind of exception. It will also be good if you could just add several invoke workflows in the whole process. I am currently working in a big MNC sir...and it's all because of you sir. Thanks in advance.

[@AutomatewithRakesh]

Thank you the suggestions. And congratulations for your new job!

[@vinayawasthi9241]

@@AutomatewithRakesh thank you so much sir....if you haven't uploaded these videos I wouldn't be able to crack interviews. Sir please upload a video on my suggestion, humble request.

[@toshi_garg]

If we see your data carefully, these are not actually 10 digit Ph numbers and that's why your code worked. If you put 10 digit Ph numbers in your excel file then it will throw Argument Exception "Add Data Row: Value was either too large or too small for an Int32." and your code will not execute. In real time scenerios, these would be actual 10 digit Ph nos so please try it and let me know how we can make it work witl 10 digit nos.

[@sarumathip.7312]

Hi, In my excel i have 3 or more string that means tesla,apple,mac,ford how can i define that assign

[@ksashmita]

If some of the rows have data with /, ; but other rows have only single data then how to use delimeter in this case

[@gnanaprakasam8721]

Hi bro I have one doubt, if we have name column like Last name and first name, want to be write in one column like Full name, how to do bro. Please 🙏 help me.

[@abi8896]

Assign:FullName-FirstName+" "LastName

[@ramkumpatla4021]

How to contact you?

[@maheshbaraskar4565]

Can you provide excel file for practice

[@AutomatewithRakesh]

Hi Mahesh I think it was bit long and I have deleted the sheet! Looking at the example you can easily create one

[@maheshbaraskar4565]

@@AutomatewithRakesh yeah it's ok..thank you

[@srinivaschaduvala5687]

am not getting result, please provide coding on this video related