How to Remove Rows in Datable, if it contains a line break

I have an excel file that I read which sometimes contains a line break.
For Example:

Upon reading it as a datatable, it would output like this:
Break Line
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

Cheers @Shinjid


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.