topic Re: add negative sign in the data in Talend Studio

add negative sign in the data

Anonymous — Wed, 07 Mar 2018 09:14:22 GMT

Hello,

I have a bunch of data in the excel sheet and from talend I read those data and insert into the table. But when the amount is negative it still inserted as a positive number and that's why I am getting the wrong total of amount.

Example :: value = (100) is equivalent to -100.
Negative value comes in ().
I tried this but it's not working.

StringHandling.RIGHT(row27.line, 1).equals("(") ? 
"-" + StringHandling.EREPLACE(row27.line, "(", "") : row27.line

@TRF Can you please help me out.

Re: add negative sign in the data

TRF — Wed, 07 Mar 2018 09:23:33 GMT

Try this:

row27.line.contains("(") ? "-" + row27.line.substring(1, row27.line.length()-1) : row27.line

Re: add negative sign in the data

Anonymous — Thu, 08 Mar 2018 05:15:36 GMT

@TRF I tried this and it's working fine.

Thanks for your help.

Re: add negative sign in the data

TRF — Thu, 08 Mar 2018 07:27:47 GMT

You're welcome