convert decimal (comma to dot) postgres

[Anonymous]

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
_________________________________________________________________

[Anonymous]

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?