I have an excel file that I read which sometimes contains a line break.
Upon reading it as a datatable, it would output like this:
This usually appears in two of my columns, So i think I can just check both columns. How to I check for line breaks in datables?
Did we refer this thread where we can use FILTER DATATABLE activity with contains
Thanks. This works, I was using “vBCrlf” as the value before, no wonder why it isn’t working before.
rowData(“With Break”).ToString + " : " + rowData(“With Break”).ToString.Contains(vbLf).ToString
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.