• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] AS400 transform float to string

#1 2010-01-05 17:32:39

vincent31
New member
Registered: 2009-12-22
Posts: 6

[resolved] AS400 transform float to string

Tags: [float, string]

Hello,

I want to transform a float in string! In the database, data are save in float and look like "20091211". When i use a tLogRow just after tAS400Input, data look like "2.0091211E7". I use tMap with ""+mydata to transform in string, but the transformation is "2.0091211E7" not "20091211". I don't know how i can transform float to string!

Can you help me to begin ?

Sorry for my poor english!

thanks!

Offline

#2 2010-01-06 04:45:45

shong
Talend team
Registered: 2007-08-29
Posts: 10354
Website

Re: [resolved] AS400 transform float to string

Hello
see a related [Forum, topic 2729] How to convert Double DataType in Date.

Best regards

         shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2010-01-06 09:38:17

vincent31
New member
Registered: 2009-12-22
Posts: 6

Re: [resolved] AS400 transform float to string

It works fine! Thanks!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] AS400 transform float to string

Board footer

Powered by FluxBB