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.Platform.ResourceHandling System.Reflection System.Runtime.InteropServices System.Text.RegularExpressions System.Collections.ObjectModel System.Activities.DynamicUpdate System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities 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.Studio.Constants UiPath.Platform System.Reflection.Metadata System.Memory Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition System.ServiceModel NPOI UiPath.System.Activities.Design System.Runtime.Serialization UiPath.Excel.Activities.Design UiPath.Excel UiPath.Excel.Activities True [mc] [System.Text.RegularExpressions.Regex.Matches(strData,"(?<=^|\n)1ABCD123[\s\S]*?(?=1ABCD123|$)")] True [rundate] [System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<=RUN\s*DATE:\s*)\w+\s+\d{2},\d{4}").Value] [fileno] [System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<=FILE\s+NO\.\s*:\s*)\d+").Value] [fileid] [System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<=FILE\s+ID\s+:\s*)\S+").Value] [paidDate] [System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<=PAID\s+DATE\s*:\s*)\w+\s+\d+.\d+").Value] [strAmountItemList] [System.Text.RegularExpressions.Regex.Match(currentItem.Value.Trim,"(?<=(.*\r?\n){2}\s*\S.*?\s{2,})\S.*(?=\r?\n)").Value.Trim] [strAfterAmoutItemList] [System.Text.RegularExpressions.Regex.Match(currentItem.Value.Trim,"(?<=^(.*\r?\n){3}).*").Value.Trim] [strListOfItems] [System.Text.RegularExpressions.Regex.Match(currentItem.Value.Trim,"(?<=^(.*\r?\n){9}).*").Value.Trim] True False False True [strItemsPart] [System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<=STUDENT/TECH\s+NAME\s+STUDENT\s+REFERENCE\s+NO\.\s+AMOUNT[^\r\n\S]+\r?\n[^\r\n\S]*\r?\n)[\s\S]+").Value] False False [mcItem] [System.Text.RegularExpressions.Regex.Matches(strData,"(?<=^|\n)\s+(?<ABCTYPE>\w*)\s+(?<ABCCDE>\d+)\s+(?<VALUEDATE>\w+\s\d+)\s+(?<OTHENUM>\d+-\d+)\s+(?<STUDENTID>[-\d]+)\s+(?<STUDENT_TECHNAME>.*?)\s+(?<STUDENTREF>\w+)\s+(?<AMOUNT>\$[\d.,]+)(\s+\*(?<STUDENT_CODE>.*?)(?=\*))?")] True False True [m] [System.Text.RegularExpressions.Regex.Match(currentItem2.Value,"(?<=^|\n)\s+(?<ABCTYPE>\w*)\s+(?<ABCCDE>\d+)\s+(?<VALUEDATE>\w+\s\d+)\s+(?<OTHENUM>\d+-\d+)\s+(?<STUDENT/TECHACCOUNTNO>[-\d]+)\s+(?<STUDENT/TECHNAME>.*?)\s+(?<STUDENTREF>\w+)\s+(?<AMOUNT>\$[\d.,]+)")] False False True False False True True False False [abctype] [currentItem2.Groups("ABCTYPE").Value] [abccde] [currentItem2.Groups("ABCCDE").Value] [valueDate] [currentItem2.Groups("VALUEDATE").Value] [otherNum] [currentItem2.Groups("OTHERNUM").Value] [studentId] [currentItem2.Groups("STUDENTID").Value] [studentName] [currentItem2.Groups("STUDENTNAME").Value] [studentRef] [currentItem2.Groups("STUDENTREF").Value] [amount] [currentItem2.Groups("AMOUNT").Value] [studentCode] [currentItem2.Groups("STUDENT_CODE").Value] True False False