topic tMap: Padding Number. in Talend Studio

tMap: Padding Number.

ptremblay — Sat, 16 Nov 2024 14:21:12 GMT

Bonjour,
I'm no Java specialist.
I would like to have my Numeric.sequence in the following fix format: "S00000000" (with padding "0").
sequence 0 -> S00000000
sequence 1 -> S00000001
..
sequence 111 -> S00000111
etc.
I can convert a number to a string but I cannot make it in this precise format.
Thanks.
PM

Re: tMap: Padding Number.

amaumont — Wed, 28 May 2008 16:36:27 GMT

Try this:

"S" + new java.text.DecimalFormat("00000000").format(111)

Re: tMap: Padding Number.

ptremblay — Wed, 28 May 2008 16:43:03 GMT

It works now.
This also teaches me on how to use java within the Expression Editor.
Many thanks.
PM