# How to insert Space to replace Null by Reformat

**URL:** <https://forum.cloverdx.com/t/how-to-insert-space-to-replace-null-by-reformat/1314>\
**Category:** CloverDX Platform\
**Created:** [December 3, 2013, 12:00am UTC](https://forum.cloverdx.com/t/how-to-insert-space-to-replace-null-by-reformat/1314 "2013-12-03T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jean](https://avatars.discourse-cdn.com/v4/letter/j/fbc32d/32.png) [@jean](https://forum.cloverdx.com/u/jean)\
**Post date:** [December 3, 2013, 12:00am UTC](https://forum.cloverdx.com/t/how-to-insert-space-to-replace-null-by-reformat/1314/1 "2013-12-03T00:00:00Z")

</div>

Hi,

I would like to transform data from Input table to Output table, fields type of Output table is Not Null.  
I have an question about how am I replace null by space if the field is null by use Reformat. For example data as in the attached file. Please give me the guideline how to use reformat to transform it.

Thank you.

- [ExampleOfSpaceReplaceNullByReformat.jpg](https://cdn.cloverdx.com/forum/17467%5Ffb83abbd5f3fdb6b7e2ecb477bffe357/ExampleOfSpaceReplaceNullByReformat.jpg)

---

<div class="post-metadata">

**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\
**Post date:** [December 4, 2013, 9:19am UTC](https://forum.cloverdx.com/t/how-to-insert-space-to-replace-null-by-reformat/1314/2 "2013-12-04T09:19:30Z")

</div>

Hi Jean,

I would use something like this:

if (isnull($in.0.A)) {$out.0.A = " ";}  
if (isnull($in.0.B)) {$out.0.B = " ";}  
if (isnull($in.0.C)) {$out.0.C = " ";}  
if (isnull($in.0.D)) {$out.0.D = " ";}  
if (isnull($in.0.E)) {$out.0.E = " ";}

OR

$out.0.A = nvl($in.0.A, " ");  
$out.0.B = nvl($in.0.B, " ");  
$out.0.C = nvl($in.0.C, " ");  
$out.0.D = nvl($in.0.D, " ");  
$out.0.E = nvl($in.0.E, " ");

Does it meet your requirement?

Kind regards,

---

<div class="post-metadata">

**Author:** ![jean](https://avatars.discourse-cdn.com/v4/letter/j/fbc32d/32.png) [@jean](https://forum.cloverdx.com/u/jean)\
**Post date:** [December 4, 2013, 10:33am UTC](https://forum.cloverdx.com/t/how-to-insert-space-to-replace-null-by-reformat/1314/3 "2013-12-04T10:33:23Z")

</div>

Hi Imriskal,

Yes, it is work in the second solution. Thanks.