How to convert negative values to () brackets

[Anonymous]

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]

@ravi777,try this one

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

[manodwhb]

@ravi777,still do you have this issue?