System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup UiPath.Vision.OCR UiPath.OCR.Contracts System.Text.RegularExpressions System.Xml.Serialization UiPath.Excel System.Activities Microsoft.VisualBasic mscorlib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Vision.Core UiPath.OCR.Contracts UiPath.Excel.Activities True True [FromDate] [System.Text.RegularExpressions.Regex.Match(Pdfout,"[0-9]{2}-[A-Za-z]{3}-[0-9]{4}.*.to").Value.Trim.Replace("to","")] [ToDate] [System.Text.RegularExpressions.Regex.Match(Pdfout,"to.[0-9]{2}-[A-Za-z]{3}-[0-9]{4}").Value.Trim.Replace("to","")] [Employee_Code] [System.Text.RegularExpressions.Regex.Match(Pdfout,"Employee Code.*.[0-9]{2,}").Value.Trim.Replace("Employee Code:-","")] [Employee_Name] [System.Text.RegularExpressions.Regex.Match(Pdfout,"Employee Name.*").Value.Trim.Replace("Employee Name:-","")] [Total_Duration] [System.Text.RegularExpressions.Regex.Match(Pdfout,"Total Duration\s-\s[0-9]{1,}:[0-9]{1,}").Value.Trim] [T_Duration] [System.Text.RegularExpressions.Regex.Match(Pdfout,"T Duration.*").Value.Trim.Replace("T Duration","")] True [Counter] [1] [words] [T_Duration.Split({" "c}, StringSplitOptions.RemoveEmptyEntries)] True [Counter] [Counter +1] True False