Create Function class in My Routine

[DY94]

Hi,

Anyone Can help me to fix my Java Function to use it in my Routine.

The Function will remove exponent and put it in a Float format.

This is the function :

float amount = 3.53435E12;

java.text.DecimalFormat df = new java.text.DecimalFormat("# .# ");

String s=df.format(amount );

System.out.println("amount = " + s);

it will convert the number format from this 3.53435E12 to this 3 534 350 000 000

the result will be like this ---> 3 534 350 000 000

Now i want to create a function in my Routine in order to use it in Tmap with my column.

Thanks.

[Anonymous]

Hello

Here is a KB article that shows you how to create a user routine and call it in a job. Please try and let me know if you have any questions.

Regards

Shong