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 System.Collections.ObjectModel System.Activities.DynamicUpdate System.Reflection System.Runtime.InteropServices UiPath.PDF.Activities System.ComponentModel System.Runtime.Serialization UiPath.Activities.System.Compression.Zip UiPath.Activities.System.Encode UiPath.Activities.System.Compression.Workflow UiPath.Shared.Activities Microsoft.Exchange.WebServices.Data UiPath.Mail System.Security UiPath.Mail.Exchange.Activities UiPath.Mail.Activities UiPath.Core.Activities.Orchestrator System.Text.RegularExpressions System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities System.Data.DataSetExtensions UiPath.System.Activities.Design System.ValueTuple UiPath.Excel UiPath.Mail UiPath.OCR.Activities.Design System.Memory UiPath.UIAutomationCore Microsoft.Bcl.AsyncInterfaces UiPath.PDF.Activities System.ServiceModel System.Runtime.Serialization System.ComponentModel.Composition Microsoft.Exchange.WebServices UiPath.Mail.Activities System.Runtime.WindowsRuntime True True [PDFFile] [string.Join(",", PDFOutput)] [Alloc] [Offices] [FileList] [Directory.GetFiles("C:\temp\AppliedInnovations\", "*.pdf")] True [FoundIt] False [FileCounter] 0 [TextPointer] 0 [InvoiceFileName] [FileList(FileCounter)] [Spaceless] [PDFText.Replace(" ","")] [TextPointer] [Spaceless.IndexOf("InvoiceDate:")] [dtInvoiceDate] [Spaceless.Substring((TextPointer+12),10)] [dtInvoiceDate] [dtInvoiceDate.Substring(6,4) + dtInvoiceDate.Substring(0,2) + dtInvoiceDate.Substring(3,2)] True [TextPointer] [PDFText.IndexOf("Bill Number:")] False False True [EndPointer] [PDFText.IndexOf("KKA")] False False True [BillNo] [PDFText.Substring(TextPointer+12, (EndPointer - (TextPointer+12)))] False False True [BillNo] [BillNo.Trim] False False True [BillNo] [BillNo.Substring(0,6)] False False [TextPointer] [Spaceless.IndexOf("Balance$")] [EndPointer] [Spaceless.IndexOf("PDFGeneratedon")] [InvoiceAmount] [Spaceless.Substring(TextPointer+8, (EndPointer-(TextPointer+8)))] [InvoiceAmount] [InvoiceAmount.Replace(",","")] [InvoiceAmount] [FormatNumber(InvoiceAmount,2)] [InvoiceAmount] [InvoiceAmount.Replace(",","")] [InvoiceAmtDbl] [Convert.ToDouble(InvoiceAmount)] True True [InvoiceDesc] ["Website Hosting, Firewall, Cloud Server and Azure Disaster Recovery"] True [InvoiceDesc] Backup for Servers for Website [TextPointer] [Spaceless.IndexOf("Invoice#")] [EndPointer] [Spaceless.Indexof("InvoiceDate")] [InvoiceNumber] [Spaceless.Substring(TextPointer+8, (EndPointer-(TextPointer+8)))] [InvoiceNumber] [Trim(InvoiceNumber)] True [AlphaNumericBatch] ["AI" + InvoiceNumber] [AlphaNumericBatch] [AlphaNumericBatch.Replace(vbCrLf,"")] [ShortFileName] [InvoiceFileName.Substring(InvoiceFileName.LastIndexOf("\")+1)] [OutputTextFile] ["C:\temp\AppliedInnovations\BatchEInvoice-KLMH-prod-" + dtInvoiceDate + "-0000-" + AlphaNumericBatch + "-Invoice-KelleyDrye.txt"] True [LineNumber] 1 [ArrayCount] [UBound(Alloc) + 1] [OutputString] [HeaderRow] True [AllocShare] [InvoiceAmtDbl * Alloc(LineNumber - 1)] [AllocShareString] [FormatNumber(AllocShare.ToString, 2)] [AllocShareString] [AllocShareString.Replace(",","")] [OutputRow] ["KLMH|" + ShortFileName + "|36096||REMIT|" + InvoiceNumber + "|" + dtInvoiceDate + "|" + InvoiceAmount + "||06781||||||" + InvoiceDesc + "|||||||||" + AllocShareString + "|||||808116|" + InvoiceDesc + "||||Firm Expense|||" + Offices(LineNumber - 1) + "|38|||||||||"] [OutputRow] [OutputRow.Replace(vbCrLf,"")] [OutputString] [OutputString + CrChar + OutputRow] [LineNumber] [LineNumber + 1] [OutputTextFile] [PDFFile]