String to Date convert

[DrGenious]

Hi,

I have a column with strings like "2.02E+13". How can I make them Date type? 

Thanks a lot.

[TRF · Accepted solution]

2.03E+13 is equal to 20 200 000 000 000 which doesn't represent a valid date, so...
Any way, you can convert your input to a string using String.format("%.0f", row1.yourValue) then use TalendDate.formatDate to convert the result to a date

[DrGenious]

The solution I found is to convert my string to bigdecimal ,after to plainString and then parse it into .parseDate. But I will try also you solution. Thanks a lot for your help.