topic Re: Left-Padding Integer With Zeroes in Talend Studio

Left-Padding Integer With Zeroes

HLeyes — Fri, 02 Jan 2015 17:30:06 GMT

I have an integer field in tMap, which may have integers from 1 to 100, for example. How can I output a 4-character string field with zeroes on the left? For example, the integer '1' would be '0001'. The integer '100' would be '0100'.
Thanks in advance,
HL
Fort Myers, FL

Re: Left-Padding Integer With Zeroes

Anonymous — Sat, 03 Jan 2015 11:19:16 GMT


   /**
     * formats the number
     * 
     * {Category} NumberUtil
     * 
     * {talendTypes} String
     * 
     * {param} Integer(1234) number: number to format
     * {param} Integer(6) lengthWithLeadingZeros: length with leading zeros
     * 
     * {example} numberToString(1234, 6) result: 001,234
     * 
     */
public static String numberToString(Integer number, int lengthWithLeadingZeros) {
 if (number != null) {
 String s = String.valueOf(number);
 String rawString = s.replace(".", "").replace(",", "");
 System.out.println(rawString);
 if (lengthWithLeadingZeros > rawString.length()) {
  StringBuilder sb = new StringBuilder();
  for (int i = rawString.length(); i < lengthWithLeadingZeros; i++) {
  sb.append('0');
  }
  sb.append(s);
  return sb.toString();
 } else {
  return s;
 }
 } else {
 return "";
 }
}

Create a routine called e.g. NumberUtil and add this method.
Call this in an expression like:

Numberutil.numberToString(row1.my_int_value, 9)

this will fill the integer to a string length of 9 with the necessary zeros.

Re: Left-Padding Integer With Zeroes

Anonymous — Fri, 15 Jul 2016 10:17:47 GMT

Hi-
use below expression in Tmap if ur column is string.
StringHandling.RIGHT(("0000" +row1.columnname ),4).
Regards-
Raghav K

Re: Left-Padding Integer With Zeroes

Anonymous — Fri, 15 Jul 2016 11:04:17 GMT

or, finally, you can use

String.format("%04d", row1.myNumber)

if your data type is Integer rather than int, you may want to perform some null testing first, and take appropriate action.

Re: Left-Padding Integer With Zeroes

vharcq — Mon, 12 Sep 2016 13:27:04 GMT

Apache Commons make this easy

org.apache.commons.lang.StringUtils.leftPad(nationalRegisterNumber, 11, '0')

Re: Left-Padding Integer With Zeroes

Anonymous — Tue, 31 Jul 2018 13:57:57 GMT

for integer datatype...how to write right paded with space

Spoiler