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.Text.RegularExpressions System.Xml.Serialization System.Globalization Microsoft.Activities.Expressions System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities PresentationFramework WindowsBase PresentationCore System.Xaml System.ComponentModel.Composition System.ServiceModel UiPath.IntelligentOCR UiPath.Python System.Data.DataSetExtensions Microsoft.Activities [FileList] [Directory.GetFiles("C:\Users\Krishna\Desktop\Input","*.xlsx")] [ColumnI] [arr] [row(11).ToString.Split({"^","CUSTOMER ID "},StringSplitOptions.RemoveEmptyEntries)] [ColumnL] [arrayColumnL] [ColumnL.ToString.Split({"^"},StringSplitOptions.RemoveEmptyEntries)] [Credit] [arrayColumnL(0)] [Dept] [arrayColumnL(1)] [Store] [arrayColumnL(2)] [ID] [arrayColumnL(3)] [arrayDate] [ID.Split(" "C)] [row("Store")] [row("Store").ToString.Insert((row("Store").ToString.IndexOf("#")+1)," ")] [row("Store")] [System.Text.RegularExpressions.Regex.Replace(row("Store").ToString,"(')","")] [ResultDT.DefaultView.Sort] [("[Store] ASC")] [ResultDT] [ResultDT.DefaultView.ToTable] [mainDT] [ResultDT.DefaultView.ToTable(true,"Date")] [distinctDate] [date_convert] [distinctDate.Substring(1,8)] [Date_conversion] [DateTime.ParseExact(date_convert.ToString() ,"MMddyyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM-dd-yyyy")] dzVDOlxVc2Vyc1xLcmlzaG5hXERvY3VtZW50c1xVaVBhdGhcQkJUIEZpbGVzXE1haW4ueGFtbG5EA8YCDgIBAUc4R1UCAQZIOEhVAgEFTzhPVQIBBFA4UFUCAQNROFFVAgECUwVTuA0DAZIBVAVbDgMBjgFcBdYBEgIBRtcBBfUBFQIBOvYBBf0BDgIBN/4BBYUCDgIBMoYCBY0CDgIBLY4CBcQCFQIBB1MiUy4DAZMBWTJZcQMBkQFWM1Y9AwGPAVx4XIQBAwGMAWIL0wEWAgFH1wEe1wEqAgFE3QEL8gEWAgE7+wEw+wFBAgE5+AEx+AFMAgE4gwI0gwJSAgE1gAI1gAI/AgEziwI0iwJfAgEwiAI1iAI9AgEujgIejgIoAgErlAILwQIWAgEIYw10KAMBgwF1DdIBHQIBSN4BDekBEgIBP+oBDfEBFgIBPJoCDZoCsQ0CASibAg2fAh0CASKgAg2vAh0CARiwAg23AhYCARS4Ag2/AhYCARDAAg3AAqsCAgEJY6gBY7ABAwGKAWkTcR4DAYQBdSZ1NwMBgQF7E88BHgIBSd4BG94BnQECAUDgARHnARoCAUHvATjvAYYBAgE+7AE57AFHAgE9mgIqmgI2AgEpnQJAnQJOAgEmmwKiAZsCrQECASSbAlCbAlMCASOgAiagAjICASCmAhOsAh4CARm1Aji1AlUCAReyAjmyAkcCARW9Aji9ArsBAgETugI5ugJKAgERwAKuAcACsgECAQ/AAjjAAkQCAQ3AApgBwAKgAQIBDMACwAHAAqgCAgEKahVwKQMBhQF8Fc4BIAIBSuUBPOUBhgECAUPiAT3iAUsCAUKnAhWrAhoCARpqRWpWAwGIAW0bbUoDAYcBaq0BarUBAwGGAYEBF4UBJwIBe4YBF80BHAIBS6cCI6cCWgIBG6kCGakC3QICARyDAUqDAVMCAX+BAawBgQGzAQIBfYEBWoEBXQIBfIYBJYYBmQECAUyIARvLASYCAU2pAoQCqQKQAgIBHqkCRKkC+QECAR2MAR2TASYCAXeUAR2YAS0CAXGZAR2ZAYsBAgFvmgEdoQEmAgFrogEdqQEmAgFmqgEdsQEmAgFhsgEduQEmAgFcugEdwQEmAgFXwgEdyQEmAgFSygEdygHbAQIBTpEBSpEBngECAXqOAUuOAVACAXiWAVCWAVkCAXWUAbMBlAG6AQIBc5QBYJQBZAIBcpkBdJkBiAECAXCfAUqfAY8BAgFunAFLnAFZAgFspwFIpwFZAgFppAFJpAFRAgFnrwFIrwFZAgFkrAFJrAFPAgFitwFItwFZAgFftAFJtAFQAgFdvwFIvwFZAgFavAFJvAFNAgFYxwFKxwFaAgFVxAFLxAFWAgFTygGCAcoBjgECAVDKAUjKAXcCAU8= False False True False False True True True True False True False False True False False True True True False True False False True