Remove whitespace only values (Clean up) in Sanitize text

1

Hi,
first … happy new year to all.

I have a little problem: The “Remove whitespace only values” (Clean up Action) does all i want in my case. Unfortunately it works only with given Columnnames.

It would be great, if the Sanitize Action would have the Option.

Is it possible?

regards,

Adrian

1 Like
2

Hello. I am also looking for a way to remove whitespace table-wide (or in multiple columns at once). I did some searching, but have not found an answer to this since the original post here. My goal is for the Table metadata to reliably calculate "Empty count" in all columns. I am finding fields with whitespace are not counted as empty, and only "Clean up" seems to correct the issue. Unfortunately, there are too many columns to handle one-by-one with the "Clean up" function. Any ideas anyone?

3

Hi Lisa and welcome to the Community!

Here is a project that replaces zero-length text values with just empty values for all columns using the "Iterate columns" action.

remove-empty-text.morph (3.9 KB)

PS. If you have any questions regarding how the project works, don't hesitate to ask.

4

Thank you, Dmitry. I will give this a try!

5

Exactly how I do it. Is there any reason the clean up action can't have this?

image

6

I hear you. We will add this option in the next release.

1 Like
7

"Clean up" can now work with all or multiple selected columns. Available in v5.7.2.

image

2 Likes