You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » string to float, problem with %
#1 2008-07-20 23:08:32
- covenant13
- Member
- Registered: 2008-05-19
- Posts: 10
string to float, problem with %
Hello,
I have in the file column with data e.g. 1,44%, 4,67%. I want to put to base 1.44, 4.67. I do it then:
Float.parseFloat(StringHandling.CHANGE(StringHandling.CHANGE(StringHandling.CHANGE(row2.Column2,"%",""),",","."),"-","0")).
When I run test on the:
Float.parseFloat(StringHandling.CHANGE(StringHandling.CHANGE(StringHandling.CHANGE("1,44%","%",""),",","."),"-","0")) it works.
But in my project it put to base 0.014, 0.047 and send messages:
Warning: Invalid parent format found - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Debug: format string is #0.00%;\-#0.00%;0.00%;
Debug: format string is \?#,##0.00;\-\?#,##0.00;\?0.00;
Debug: format string is #,###;\-#,###;0;
Debug: format string is #,##0.00;\-#,##0.00;0.00;
What is wrong? Is it a bug?
Thanks for help.
Offline
#2 2008-07-21 16:48:39
- jamesB
- Member
- Registered: 2008-03-19
- Posts: 47
Re: string to float, problem with %
Hi i have your same problem,
when i execute my job i have this warnings :
Warning: Invalid parent format found - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Debug: format string is #0.00%;\-#0.00%;0.00%;
Debug: format string is \?#,##0.00;\-\?#,##0.00;\?0.00;
Debug: format string is #,###;\-#,###;0;
Debug: format string is #,##0.00;\-#,##0.00;0.00;
I'm wrking on excel files, but when wrote on the console of this warnings my job become slow!!
how can i deactivate them?
Regards,
JamesB
Whatever you are, be a good one..
Offline
#3 2009-07-22 19:44:21
- simony
- Guest
Re: string to float, problem with %
anyone has any idea how to fix this problem?
i'm writing to a sheet with no formatting at all and still have this warning come out...
but i do have another worksheet pointing to the cells in this sheet which has formatting with decimal precision point and comma separator and such
thanks.
#4 2010-05-05 16:58:28
- maestro
- New member
- Registered: 2010-05-05
- Posts: 1
Re: string to float, problem with %
Hi,
Have you fixed the problem ?
I have the same problem with a simple job :
tFileExcelInput --> tMap --> tFileOutputDelimited
Warning: Object record is not associated with a drawing record - ignoring
Warning: cannot find comment for note id 88...ignoring
Thanks for your help
Maestro
Offline
#6 2011-04-11 04:24:01
Re: string to float, problem with %
Hi
Try to read the data as a string and then handle and convert it to float on tMap.
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!
Online
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » string to float, problem with %