add negative sign in the data

Six Stars

add negative sign in the data

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. 


Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: add negative sign in the data

Try this:

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

TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: add negative sign in the data

Try this:

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

TRF
Six Stars

Re: add negative sign in the data

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

Thanks for your help.

Forteen Stars TRF
Forteen Stars

Re: add negative sign in the data

You're welcome


TRF