How to insert Space to replace Null by Reformat

jean

• December 03, 2013 00:00

• Answered

Follow

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

• 

  imriskal

  • December 04, 2013 09:19

  0

  Comment actions Permalink

  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,
• 

  jean

  • December 04, 2013 10:33

  0

  Comment actions Permalink

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

Please sign in to leave a comment.