If you like this video, then you will love the UiPath Document Understanding tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cp1hbChzUQ4.html, where you'll learn how to use the Document Understanding package (invoice). Thanks for all your support 😊
Great explanation! I like your content! However, I prefer doin this kind of stuff in C# (invoke code). Just a few lines of code instead of an entire screen ;). Anyway, thks for sharing ! Keep goin!
Hi Anders! Great video! When making the matches segment and write line ienMatches(0).Value, how would you do it if your email contained an unknown number of Case ID's? For example the email you were working on. How would you extract and print out an unknown number of Case ID's if every email contained more than one. Could be 1 but could also be 20? How can i then make it so it saves all 20 Case ID's to the excel sheet?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html Kind regards, Anders
Hello Anders Please help me! I am automating web scraping. I have the following problem: the site opens a new tab automatically. UIpath can open the new tab, but it returns automatically to the initial page (so, I cannot make clicks, etc on the page opened). I used the command Ctrl + Tab, but didnt work. How can I solve this?
Hey JRR. What site? Kind regards, Anders Ps. Can you post the problem in my FB group: "UiPath RPA Professionals", then I solve it for you and others can benefit? Kind regards, Anders
Hi , i am getting error in assign activity that "object reference is not set to an instance of object"when try to assign dtResult.Rows(intIndex).Item(Rows.Item("Name").ToString Pls help me to resolve this issue....
Hey Riya Sharma Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hey MiHir. Thanks a lot 🙂 Unfortunately I don't have time for specific questions 1-to-1, but feel free to post the problem in the Facebook group (link is in the description), and we'll solve it. Kind regards, Anders
Hello Anders, i like your video. I would like to question if with this method I could read messages not structured of Outlook for example to extract date, keywords of subject and also of body of every one this messsages answered, forward, received and finally to copy the data to excel spreadsheet. Best, regards. Message 1 date Body -------------------------------- Message 2 date Body ----------------------------------- Message 3 date Body
Hey Sandra Bello-M3 Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hello Anders, I’ll watch your videos which mostly solve my issues but I’m trying to extract the table data from an email outlook with regex how can I do that. I tried with front end but it’s kind of a complex process so thought of using regex to extract table data.
Hey Susmitha Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hey Andrzej. Great question. It's the best practice naming convention (camelCase like eBay). We start with a small letter, then we write something to indicate what variable type it is (e.g. ien for IEnumerable, str for String or int for Integer). The next word is a describing name and that starts with a capital letter. So basically "just" a name 🙂 But a naming convention I can recommend. Kind regards, Anders
Hi sir.. I need to click on all the links with yes from the Outlook email body but this yes no option won't be there on actual email and download all the files and merge all the data in one excel...
Hey Syed Sultan Ahmed Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hi Anders, a very great tutorial. But I am kind of having difficulty to understanding on the following. dtOutput.rows(intIndex).item(row.item(“Name”).ToString) = ienMatches(0).Value May I know what is the “0” value is referring to in dtRegex? I guess is the column “Name” in the dtRegex, but not sure is it correct, please enlighten. Thanks :)
Hey Julie. Thanks a lot :) Yeah, sometimes it can be a bit complicated. The 0 simply just means, that we want the first match. It's zero-indexed so the first match can be referred to by 0, the second match by 1 and so on. Often there will only be one match (and there fore it's the first), but you will create some workflows with multiple matches, where you might want to refer to some other match than the first (or maybe all of them). I hope this helped you. Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html Kind regards, Anders
Hey Tiffany Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
hi anderson , i tried this today but not getting expected results . I am getting a blank row after the headers , and my regex retrieved data is overwritten on the blank row
Hey RPA. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ru-vid.com/show-UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hey Jafrul Hasan Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hey N.A. S. Thank you very much 🙂 We can use Regex. Find the signature using a Regex pattern. Then do a .replace. I'll gladly show you, can you post your (anonymized) email on either my FB or Discord? Then I can solve it so many can benefit 🙂 Kind regards, Anders
Hello sir.. I've started watching your videos recently and would like you to suggest VB commands for uipath and also I want to retrieve the row wise data in Excel n copy that retrieved data into another excel file. Could you please suggest how to do this automation. Any kinda answers will be appreciated thank you..
Hey Kiran. Thanks a lot. Sure. Read both the Excel sheets into Data Tables and iterate through the first using a For Each Row. Then use a Add Data Row inside with the dtAnotherDataTable and in array {row.item("yourColumnNameInTheFirstExcel").ToString} Finally write it back to Excel. Let me know if you can solve it or feel free to post the question in my FB group "UiPath RPA Professionals". Kind regards, Anders
@@andersjensenorg Sorry sir, tried of it but, didn't get the desired result. Could you please do a clip for that. Actually, I'm a beginner who's been learning uipath since a month. Got this as assignment task.kind regards, kiran .
In Assign, for this part: dtOutput.Rows(intIndex).Item(row.Item("Name").ToString) I'm getting error: Argument "To": Compiler error(s) encountered processing expression "dtOutput.Rows(intIndex).Item(row.Item("Name").ToString)". Option Strict On disallows implicit conversions from "String" to "integer". (Studio 2021 4.3)
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xWFz-S96XGo.html Kind regards, Anders
Hey Osheen. Thank you, I'll gladly solve it for you, but will be very complicated in a YT comment. Feel free to join this: ru-vid.com/show-UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ and post the question. Kind regards, Anders
Hi Anders, I have tried same concept in one of my scenario but it is failing will reading some number like "123-456-789-99" It will throw error like :- "exception has been thrown by the target of an invocation." CAn you suggest?
Hey A S Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C6xmGfEL07I.html Have a great day. Kind regards, Anders
Hey Nasr. If you mean in general and for the use in UiPath, I always recommend my students to check ru-vid.com/group/PL4cUxeGkcC9g6m_6Sld9Q4jzqdqHd2HiD, which is by far the best. On several occasions, I wanted to make one myself, but I doubt I can do it better. Have a great day. Kind regards, Anders