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

[Shinjid]

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:

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?

[Palaniyappan (Forum Leader)]

Hi

Did we refer this thread where we can use FILTER DATATABLE activity with contains

Remove every row from data table except they contain line break

I have my datatable dtContent which contains rows like “ab sofort Kundeneinsatz 1st und 2nd Level Support (m/w/d) München, IT -Dienstleistung” in one cell / field. But there are a couple of instances where the above information gets split into several rows AND is duplicate in the dt. So I want to remove these rows that do not contain a line break. I already tried: Filter Data Table: Keep rows from “column1” where contains Environment.newLine But this one deletes every row in my dt.

Cheers @Shinjid

[Shinjid]

Thanks. This works, I was using “vBCrlf” as the value before, no wonder why it isn’t working before.

[sumouse (ChoboIT)]

rowData(“With Break”).ToString + " : " + rowData(“With Break”).ToString.Contains(vbLf).ToString