How do i replace 2.000- to 2.000

[gouravd_7]

Hi Team,

PLease help me to replace the numbers in table like 2.000- to -2.000 in talend job.

Please find the attached screenshot of the job.

Thanks,

Gourav Dubey 

[gouravd_7]

Hi TRF,

Yes , I know that its my responsibility to clean up my job ,I was just giving you the heads up that following your steps lead to me with the error. 

Actually the inputs given by you and Nikhil at the same time was confusing so , I followed both the steps.

Thanks for the response TRF.

[TRF]

Anyway, use CAST if you have to translate "number" to String and use the expression I give to move the negative sign to the beginning and remove the decimal point and trailing 0 to get an integer.

[TRF]

@gouravd_7, does this help?

If so, thanks to mark your case as solved (Kudos also accepted as a bonus)

[gouravd_7 · Accepted solution]

Hi TRF, 

Thanks, I was able to resolve the issue with those steps however am getting another issue with Float to string conversion in tMap but I will mark this case as resolved as my first query mentioned over here was resolved with above steps. 

Thanks alot

Do let me know incase you have float to string conversion code as the one ,I have been trying is not working.

Thanks,

Gourav Dubey