topic How to convert negative values to () brackets in Talend Studio

How to convert negative values to () brackets

Anonymous — Tue, 19 Jun 2018 13:20:32 GMT

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

-1 -7

TGT -- Output

ColA ColB

(1) (7)

manodwhb — Tue, 19 Jun 2018 13:29:01 GMT

@ravi777,try this one

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

manodwhb — Tue, 17 Jul 2018 06:13:47 GMT

@ravi777,still do you have this issue?