Table-wide replace - allow replacing 0-length strings

Hello,

It would be nice if the table-wide replace action could search for 0-length strings and replace them.

For example, I’m interested in replacing 0-length strings with a null (empty) value. I know I can unpivot, filter out the 0-length rows and then pivot again, but if the whole column is 0-length strings I lose the column itself when I pivot back (I need to preserve it even though all the values are null), and I also lose the column order.

image

Thanks,

Roberto

Hi Roberto,

I asked a similar question a long time ago. Maybe this could help: Replace empty cell as text with real empty value - #7 by dgudkov

Kind regards
Nikolaas

1 Like
To learn more about EasyMorph visit easymorph.com.