topic Re: convert decimal (comma to dot) postgres in Talend Studio

convert decimal (comma to dot) postgres

Anonymous — Sat, 16 Nov 2024 14:35:13 GMT

Hi guys
It's me ... again !!!
Here is an example of my file
_________________________
15;2013;25/02/1998;3;999;1; 1003,49
15;2105;25/02/1998;3;999;1; 1003,49
...
Well I want to convert decimal text column to floating point Postgres Column.
when i try to do that i've got an cute error message
_________________________________________________________________
tarting job job_2 at 18:17 04/07/2007.
connecting to socket on port 3334
connected
Exception in component tFileInputDelimited_1
java.lang.NumberFormatException: For input string: " 1003,49"
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Float.parseFloat(Unknown Source)
at routines.system.ParserUtils.parseTo_float(ParserUtils.java:50)
at projet_1.job_2.job_2.tFileInputDelimited_1Process(job_2.java:296)
at projet_1.job_2.job_2.main(job_2.java:536)
disconnected
Job job_2 ended at 18:18 04/07/2007.
My question ...
Is there an numeric pattern or an other trick to convert my column ?
like that 1003,49 to 1003.49
THX
Regards ...
Didier
_____________________
Under Windows XP
TOS:v2.1.0.M1_r3483
Oracle 10g
Postgres 8.2.3
jre 1.6
_________________________________________________________________

Re: convert decimal (comma to dot) postgres

Anonymous — Thu, 05 Jul 2007 00:05:19 GMT

Hello
Problem is that , is not the decimal separator in Java.
You have to read your fields as a String.
Then you can parse it and convert it as a Float in a tMap : new Float(row.fieldName.replace(',', '.'))
Regards,

Re: convert decimal (comma to dot) postgres

Anonymous — Thu, 05 Jul 2007 09:40:11 GMT

hi
oki I try and i keep you informed
i saw the hour of your answer ... lol go to sleep !!!
thx a lot
Regards

Re: convert decimal (comma to dot) postgres

Anonymous — Fri, 06 Jul 2007 15:28:26 GMT

Hi ...
it work !
Thaaaaaaaanks
Have fun
Regards !

Re: convert decimal (comma to dot) postgres

_AnonymousUser — Thu, 27 Dec 2007 17:35:26 GMT

Hello Didier,
I'm facing the same trouble as you did : wanna change decimal separator ',' by '.' from string to float.
I've tried to use a tMap Component with this piece of code :new
Float(row.fieldName.replace(',', '.'))
It fails... Where should I write this expression ?
I'm new to Talend so it would be very kind to help me.

Re: convert decimal (comma to dot) postgres

Anonymous — Fri, 28 Dec 2007 07:51:41 GMT

Hi matthieu
See 1846.
Best regards
shong

Re: convert decimal (comma to dot) postgres

_AnonymousUser — Fri, 07 Aug 2009 08:02:25 GMT

Hello
Problem is that , is not the decimal separator in Java.
You have to read your fields as a String.
Then you can parse it and convert it as a Float in a tMap : new Float(row.fieldName.replace(',', '.'))
Regards,

This my problem Thank you very muchhhh... ))

Re: convert decimal (comma to dot) postgres

Anonymous — Fri, 07 Aug 2009 15:17:32 GMT

in tfileinputdelimited you can set in advanced option custom decimal separaton, so custom coding not needed
bye

Re: convert decimal (comma to dot) postgres

_AnonymousUser — Mon, 10 Aug 2009 10:53:22 GMT

Hi guys
It's me ... again !!!
Here is an example of my file
_________________________
15;2013;25/02/1998;3;999;1;1003,49
15;2105;25/02/1998;3;999;1;1003,49
...
Well I want to convert decimal text column to floating point Postgres Column.
when i try to do that i've got an cute error message
_________________________________________________________________
tarting job job_2 at 18:17 04/07/2007.
connecting to socket on port 3334
connected
Exception in component tFileInputDelimited_1
java.lang.NumberFormatException: For input string: "1003,49"
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Float.parseFloat(Unknown Source)
at routines.system.ParserUtils.parseTo_float(ParserUtils.java:50)
at projet_1.job_2.job_2.tFileInputDelimited_1Process(job_2.java:296)
at projet_1.job_2.job_2.main(job_2.java:536)
disconnected
Job job_2 ended at 18:18 04/07/2007.
My question ...
Is there an numeric pattern or an other trick to convert my column ?
like that 1003,49 to 1003.49
THX
Regards ...
Didier
_____________________
Under Windows XP
TOS:v2.1.0.M1_r3483
Oracle 10g
Postgres 8.2.3
jre 1.6
_________________________________________________________________

Problem is that , is not the decimal separator in Java.
You have to read your fields as a String.
-----------------------------------------------------------------------
tuyen dung | viec lam | tim viec

Re: convert decimal (comma to dot) postgres

_AnonymousUser — Mon, 10 Aug 2009 10:53:52 GMT

Hi guys
It's me ... again !!!
Here is an example of my file
_________________________
15;2013;25/02/1998;3;999;1;1003,49
15;2105;25/02/1998;3;999;1;1003,49
...
Well I want to convert decimal text column to floating point Postgres Column.
when i try to do that i've got an cute error message
_________________________________________________________________
tarting job job_2 at 18:17 04/07/2007.
connecting to socket on port 3334
connected
Exception in component tFileInputDelimited_1
java.lang.NumberFormatException: For input string: "1003,49"
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)
at java.lang.Float.parseFloat(Unknown Source)
at routines.system.ParserUtils.parseTo_float(ParserUtils.java:50)
at projet_1.job_2.job_2.tFileInputDelimited_1Process(job_2.java:296)
at projet_1.job_2.job_2.main(job_2.java:536)
disconnected
Job job_2 ended at 18:18 04/07/2007.
My question ...
Is there an numeric pattern or an other trick to convert my column ?
like that 1003,49 to 1003.49
THX
Regards ...
Didier
_____________________
Under Windows XP
TOS:v2.1.0.M1_r3483
Oracle 10g
Postgres 8.2.3
jre 1.6
_________________________________________________________________

Re: convert decimal (comma to dot) postgres

Anonymous — Wed, 15 Feb 2012 08:46:19 GMT

Hi,
I have a similar problem.
Input string: "139,95 ?"
Expected output: "13995" Typ int.
I've solved this problem by using the treplce component (see image), but i think it is possible to do all the stuff in tmap component? am i right?