lpad not declared

yichuansancun

• November 10, 2014 00:00

• Answered

Follow

Hello -

I have the following transformation codes but getting an error saying " function 'lpad' is not declared'

// Transforms input record into output record.
function integer transform() {

	$out.0._23_ID = "SO-" + lpad($in.0.RptTo, 8, 0);
	$out.0._26_ID = "P-" + lpad($in.0.PosNbr,8,0) + "-" + $in.0.EmplID;


	
	return ALL;
}

• 

  imriskal

  • November 11, 2014 12:15

  0

  Comment actions Permalink

  Hi yichuansancun,
  
  The third argument of lpad should be a string. If you want to use zero as the filler, use it this way: lpad($in.0.RptTo, 8, "0").
  
  Regards,
• 

  yichuansancun

  • November 13, 2014 01:36

  0

  Comment actions Permalink

  I changed the code to the following:
  
  

  $out.0._23_ID = "SO-" + lpad($in.0.RptTo, 8, "0");

  
  

  $out.0._26_ID = "P-" + lpad($in.0.PosNbr,8,"0") + "-" + $in.0.EmplID;

  
  
  I still get the error "Function 'lpad' is not declared" :(
• 

  imriskal

  • November 13, 2014 14:13

  0

  Comment actions Permalink

  What data type do you use in fields $in.0.RptTo, $in.0.PosNbr, $out.0._23_ID and $out.0._26_ID, please? For example "Nbr" in one of the names somehow suggests number while lpad function expects it to be a string. See the documentation page for lpad function.
  
  If nothing else helps, send me your whole graph, please.
• 

  julrych

  • November 13, 2014 15:43

  0

  Comment actions Permalink

  lpad function was introduced in CloverETL 4.0. Are you by any chance using version 3.5 or earlier?
• 

  yichuansancun

  • November 15, 2014 03:46

  0

  Comment actions Permalink

  yes, i am on 3.5.2 i believe
• 

  imriskal

  • November 18, 2014 10:25

  0

  Comment actions Permalink

  Hi,
  
  Our online documentation always matches to the most recent version we have. If you want to use the documentation exactly for your version, you can see it when you press F1 button directly in Designer. As my colleague mentioned, lpad is not present in CloverETL 3.5. You can use workaround like this:
  

  //#CTL2
  
  // Transforms input record into output record.
  function integer transform() {
  	string input = $in.0.field1;
  	
  	while (length(input) < 8) {
  		input = concat("0", input);
  	}
  	
  	$out.0.field1 = input;
  
  	return ALL;
  }

  I hope this helps.

Please sign in to leave a comment.