I’m on Studio.
I have an Excel with only 3 columns. One column is “Company Name”.
I’m reading it into a DataTable. I want to get the names of the companies with names that contains ‘brok’.
In the For loop, I have If condition like this:
CurrentRow.Item(“Company Name”).ToString.Contains(“brok”) AndAlso NOT string.IsNullOrEmpty (CurrentRow.Item(“Company Name”).ToString)
It gives an error at Runtime only - Object Reference not set to an instance of an object.