topic Re: how to set invalid decimal to 0 in Talend Studio

how to set invalid decimal to 0

Anonymous — Wed, 21 Nov 2018 15:00:41 GMT

I have a input field which is of double data type.
I have to write a transformation for output field, that if my input is invalid number, set to my o/p field to 0.. how to do that..?

Re: how to set invalid decimal to 0

Anonymous — Thu, 22 Nov 2018 06:06:25 GMT

Hi,

Could you please pass the input value to a double parse function and catch the exception based on the input value?

Please refer the below link for the java pseudo code.

https://stackoverflow.com/questions/3133770/how-to-find-out-if-the-value-contained-in-a-string-is-double-or-not

Based on the boolean value, you can pass the original value or zero to the output column.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: how to set invalid decimal to 0

TRF — Thu, 22 Nov 2018 06:15:44 GMT

As your input is a double, what is the criteria to decide that a number is invalid?