Thousand group separator to print a numeric sequence

Shinesei — Wed, 26 Oct 2016 14:02:42 GMT

Hi
I have, in a tMap component, a counter to count the number of records processed. The counter is defined as
name = Var.counter_Fetched
function = Numeric.sequence("counter_Fetched", 1, 1)
in a variable of type "int".
the variable is then sent to an output row concatenated with a string in the form of:
"Records cached: " + Var.counter_Fetched
the output row is, eventually, sent to a tLogRow do display, on the console, the progress.

How can I set a thousand separator for the output message?
For instance, currently at the 40000th record, it displays:
"Record cached: 40000"
I want to display
"Record cached: 40.000"

Thank you

Re: Thousand group separator to print a numeric sequence

Anonymous — Wed, 26 Oct 2016 14:41:34 GMT

Hi,
try this:

"Records cached: " + String.format("%,d", Var.counter_Fetched );
see http://docs.oracle.com/javase/tutorial/java/data/numberformat.html for more Details

regards
dj

topic Re: Thousand group separator to print a numeric sequence in Talend Studio

Thousand group separator to print a numeric sequence

Re: Thousand group separator to print a numeric sequence