Good morning Everybody,
I have a situation where I run a SQL query against the Excel file(using the OLEDB driver) and output the results to the Output DataTable(String1). Then I use remove couple words from this string using the Remove(index), and then I use an If condition to compare the String1 to String2. Unfortunately, the result of the If statement is always False. I used the “Equals” and “=” as well but looks like something is not right. As well I tried to ToLower and ToUpper and it didn’t help as well. The output of both String1 and String2 are exactly the same on the Log Message and Write Line activities. Can you please point me where I might be missing some details?