Find line break or carriage return in large table

1

How can I use easymorph to find from a table of 300 columns with 10 million rows to find any field value that has a line break and/or carriage return in it?

I’m struggling to find examples of how I can do this for the whole table and specifically how to search for these non visible characters.

2

You can use the “Iterate columns” action to check all columns for the same condition.

See the example below:

find-all-columns.morph (5.3 KB)

image
image738×411 11.4 KB