981.6,3753.6 canarabank_tblextraction_1 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.ComponentModel System.Runtime.Serialization System.Xml.Serialization System.Collections.ObjectModel System.Reflection System.Runtime.InteropServices UiPath.Excel System.Text.RegularExpressions System.Activities.DynamicUpdate UiPath.PDF.Activities UiPath.Excel.Activities UiPath.DataTableUtilities 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 System.Runtime.Serialization System.Memory UiPath.Excel UiPath.Excel.Activities.Design UiPath.Excel.Activities UiPath.PDF.Activities UiPath.System.Activities.Design System.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition UiPath.Mail UiPath.OCR.Activities.Design UiPath.UIAutomationCore System.Runtime.WindowsRuntime True False True False [dtOutput.Columns("Description").MaxLength] 500 True True False False False [strArrLines] [strTxt.ToString.Split({Environment.NewLine},StringSplitOptions.None)] True True [strArrColumns] [split(item," ")] True True False True False True True False [strTxt] [split(strTxt,"TRANS VALUE BRANCH REF/CHQ.NO")(1)] [strArrLines] [strTxt.ToString.Split({Environment.NewLine},StringSplitOptions.None)] True False False [strArrLine] [split(item," ")] [strTransDate] [strArrLine(0)] [strValueDate] [strArrLine(1)] [strBranch] [strArrLine(2)] True False True [strRefChqNo] [strArrLine(3)] [intDescStartIndex] 4 True [strDesc] [strDesc+" "+strArrLine(intDescStartIndex)] [intDescStartIndex] [intDescStartIndex+1] True [strRefChqNo] [intDescStartIndex] 3 True [strDesc] [strDesc+" "+strArrLine(intDescStartIndex)] [intDescStartIndex] [intDescStartIndex+1] [intLineIndex] 1 True False [strDesc] [strDesc+" "+strArrLines(intIndex+intLineIndex)] [intLineIndex] [intLineIndex+1] [strWithdraws] [strArrLine(strArrLine.Count-3)] [strDeposit] [strArrLine(strArrLine.Count-2)] [strBalance] [strArrLine(strArrLine.Count-1)] False False True False False True True [GetDescription] [Descr] [row("Description").ToString] [NewVal] [Split(Descr,"Statement")] True False False True False False True False True False True False False [output] [System.Text.RegularExpressions.Regex.Match(inputString,"(?<=Opening).+[\D,.]+[\d\d\s.,]+").ToString] True [InputData] [System.Text.RegularExpressions.Regex.Match(inputString,"\d,\d{3},\d{3}.\d{2}\s\d{3},\d{3}.\d{2}\s(\d,\d{3},\d{3}.\d{2})\s\d\s(\d)\s\d.\d{3},\d{3}.\d{2}.\d.\d{2}(.|\n)+").ToString] False False [InputData] [System.Text.RegularExpressions.Regex.Match(output,"(\d{3},\d{3}.\d{2})\s\d,(\d{3},\d{3}.\d{2})\s\d,\d{3},\d{3}.\d{2}\s\d{2}\s\d\s\d{3},\d{3}.\d{2}\s\d.\d{2}(.|\n)+").ToString] [InputData] [InputData.ToString.Replace(System.Environment.NewLine," ")] [newnum] [Split(InputData," ")] True False False True False False True True False False