How to convert negative values to () brackets

Anonymous · ‎2018-06-19

How to convert negative values to () brackets.

-7 to (7)

And i have columns with null values and i need that to insert as null and it should not throw any null error

SRC

ColA ColB

2

-1 -7

TGT -- Output

ColA ColB

2

(1) (7)

manodwhb · ‎2018-06-19

@ravi777,try this one

(!row3.newColumn1.equals("") || row3.newColumn1!=null) &&row3.newColumn1.contains("-")?"("+row3.newColumn1.replace("-","")+")": row3.newColumn1

manodwhb · ‎2018-07-17

@ravi777,still do you have this issue?