Thousand group separator to print a numeric sequence

[Shinesei]

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 

[Anonymous]

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