You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » string to float, problem with %
Post a reply
Topic review (newest first)
- shong
- 2011-04-11 04:24:01
Hi
Try to read the data as a string and then handle and convert it to float on tMap.
Best regards
Shong
- Mo
- 2011-04-09 10:50:06
I am facing the same error:
Warning: Object record is not associated with a drawing record - ignoring
Any help?
- maestro
- 2010-05-05 16:58:28
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
- simony
- 2009-07-22 19:44:21
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.
- jamesB
- 2008-07-21 16:48:39
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
- covenant13
- 2008-07-20 23:08:32
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.