I am trying to import data from a .txt file into a local DB.
The field "Price" is 11 chars long and is a float value without any delimiter char in the text file. E. g. possible value: "00000001500" stands for 15.00.
For data conversion I am using a tMap-Element with the conversion function: Numeric.convertImpliedDecimalFormat("999999999V99", row3.Price).
However following exception occurs: "Exception in component tMap_1, java.lang.NumberFormatException".
If I put the above value as a string constant into the function (Numeric.convertImpliedDecimalFormat("999999999V99", "00000001500")), the converting function works fine.
Thanks in advance
thank you for your response. I have verified the code, but do not see anything throwing an explicit Number.Format exception.
The code view of the tmap component is as following: "Dataconversion_tmp.Price = Numeric
What do you mean with an "error notificaton"?
Last edited by Michael.Grenz (2013-12-27 14:19:10)
I supposed there would be any error line in java code.
I did use Numeric.convertImpliedDecimalFormat before. Is it working for your case when you use [url=]https://help.talend.com/display/TalendComponentsReferenceGuide54EN/tConvertType[/url] TalendHelpCenter:tConvertType[/url].
What we can do is to make sure that Talend will be your best choice!