Hi guys, Welcome to the Advanced Video Search Engine, and you are watching UiPath: How to Extract Outlook Emails with Regex (Full Use Case). That video is uploaded by Anders Jensen at 2021-03-27T21:00:01-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [AV59DqhJa38]
| Name | UiPath: How to Extract Outlook Emails with Regex (Full Use Case) |
| Video Uploader | Video From Anders Jensen |
| Upload Date | This Video Uploaded At 28-03-2021 04:00:01 |
| Video Discription | This video tutorial shows how to extract data out of an Outlook Email Body in UiPath with the help of Regex. We go through each step of the use case in detail, so open your UiPath and create your own RPA workflow. 📁 Download Course Materials: https://andersjensen.org/how-to-extract-data-from-outlook-emails-with-regex-and-uipath/ 👪 Join my UiPath Facebook group for additional lessons and to hang out with your highly skilled colleagues: https://www.facebook.com/groups/1817369781750298 0:00 Intro Today we are again through a very cool UiPath RPA use case, where we use Regex to extract data out of Outlook emails and print it into Excel. Regex is a sequence of characters that defines a search pattern, is mostly used on structured data, and is a must-learn for any RPA developer. 1:37 Get Outlook Mail Messages and use a For Each Go to Activities and search for a "Get Outlook Mail Messages" activity. Make sure you specify the Account and Folder - especially useful when we want to move our automation between workstations. We save the emails to a list of MailMessages. We use a For Each. Here you need to remember to specify the TypeArgument to MailMessage. With the .Net properties mail.Date, mail.Subject and mail.Body we can easily extract the Date, the Subject, and the Body. With the .Net method string.contains we can check if our subject meets certain criteria. 9:10 Save Outlook Emails to Excel We create a Data Table to save our output into. For each email, we use an Add Data Row and add an array of date, subject, and body. Finally, we save the Data Table into an Excel sheet. 14:30 Extract data out of the email body with Regex We use Regex101 to create our Regular Expressions. Regex is a series of characters that defines a search pattern. It's something you need to learn as an RPA developer and is often asked in RPA interview interviews. To apply Regex in UiPath we use the Matches activity (where we define the pattern and save the output to an IEnumerable of Matches, which you can see as a list). 24:15 Create a Dynamic Regex solution in UiPath We create a Data Table with a row for each Regex pattern, we want to use in our email extraction workflow in UiPath. Afterward, we can loop through each pattern one by one and extract each thing one by one. 32:17 Move the processed emails We move our emails one by one after we've processed them. In addition, we create a unique Excel sheet every time the robot runs, so we don't overwrite it. A best practice to create unique file names is using the date and time in milliseconds, since this is unique. Connect with me: 👥 Facebook - https://www.facebook.com/andersjensenorg 🎮 Discord - https://discord.gg/d8KQpTUvFD 💼 LinkedIn - https://www.linkedin.com/in/andersjensens 💌 Email Newsletter - https://andersjensen.org/email-newsletter 📷 Instagram - https://www.instagram.com/andersjensenorg #uipath #rpa #automation AV59DqhJa38 |
| Category | Science & Technology |
| Tags | uipath | anders jensen | regex | uipath tutorial | uipath regex | regex uipath | robotic process automation | regex in uipath | rpa | uipath how to | uipath tutorial for beginners | outlook uipath | extract mail body in uipath | mail body regex uipath | how to extract emails in uipath | how to extract emails with regex in uipath | extract outlook emails with regex in uipath | uipath tutorials | save outmail emails to excel | save outlook mails to excel | regex in upath |
