# Table-wide replace - allow replacing 0-length strings

**URL:** <https://community.easymorph.com/t/table-wide-replace-allow-replacing-0-length-strings/3673>\
**Category:** Feature requests\
**Created:** [June 4, 2022, 4:59pm UTC](https://community.easymorph.com/t/table-wide-replace-allow-replacing-0-length-strings/3673 "2022-06-04T16:59:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [June 4, 2022, 4:59pm UTC](https://community.easymorph.com/t/table-wide-replace-allow-replacing-0-length-strings/3673/1 "2022-06-04T16:59:31Z")

</div>

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](https://community.easymorph.com/uploads/default/original/2X/f/f3bef33d8ca08831ff9c43e36075732eefd59774.png)

Thanks,

Roberto

---

<div class="post-metadata">

**Author:** ![reynsnivea](https://community.easymorph.com/letter_avatar_proxy/v4/letter/r/9f8e36/32.png) [@reynsnivea](https://community.easymorph.com/u/reynsnivea)\
**Post date:** [June 6, 2022, 7:49pm UTC](https://community.easymorph.com/t/table-wide-replace-allow-replacing-0-length-strings/3673/2 "2022-06-06T19:49:25Z")

</div>

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](https://community.easymorph.com/t/replace-empty-cell-as-text-with-real-empty-value/477/7)

Kind regards  
Nikolaas