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.
Thanks,
Roberto