Remove every row from data table except they contain line break

Help Studio
1

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.

2

give a try on using vbCr, vbLf especially when data comes from Excel
grafik

3

The data came from a website via data scraping but vbLf did the trick.

Thanks a lot!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.