topic Re: Project scenarios in Talend Studio

Project scenarios

Darmesh — Mon, 11 Jun 2018 07:58:37 GMT

Scenario 1 :

I have to insert comma in the values.

ex: 32825 o/p : 32,825

3281564 o/p : 3,281,564

Before third digit i have to place comma.

Scenario 2 :

I have to replace the values -7.8 to (7.8)

need to replace open and close brackets for minus values.

Re: Project scenarios

manodwhb — Mon, 11 Jun 2018 08:07:17 GMT

@Darmesh,

1:- if you were using tFileOutputExcel using to populate data,for the number filed you can specify Thousands separator.

2:- you can use the below one.

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")>0?"("+row1.filed.replace("-","")+")": row1.filed

Re: Project scenarios

Darmesh — Mon, 11 Jun 2018 09:10:43 GMT

@manodwhb

for scenario2 . am getting below error

Re: Project scenarios

Darmesh — Mon, 11 Jun 2018 09:27:32 GMT

It worked after changing into this.

row11.EBITDA_MARGIN_Dec_17 .contains("-")?"("+row11.EBITDA_MARGIN_Dec_17 .replace("-","")+")": row11.EBITDA_MARGIN_Dec_17;

Re: Project scenarios

manodwhb — Mon, 11 Jun 2018 09:37:40 GMT

try this

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")?"("+row1.filed.replace("-","")+")": row1.filed

Re: Project scenarios

Darmesh — Fri, 15 Jun 2018 10:15:28 GMT

@manodwhb

It is working fine. But sometimes column will contain null values. so how to overcome null pointer exception.

Re: Project scenarios

Darmesh — Fri, 15 Jun 2018 12:58:01 GMT

@manodwhb @TRF @rhall

It is working fine. But sometimes column will contain null values. so how to overcome null pointer exception.

Re: Project scenarios

manodwhb — Fri, 15 Jun 2018 13:22:50 GMT

Try the below one.

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")?"(row1.field==null?row1.field "+row1.filed.replace("-","")+")"): row1.filed

Re: Project scenarios

Darmesh — Tue, 19 Jun 2018 10:59:20 GMT

Error after using the below code

String literal is not properly closed by a double-quote

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")?"(row1.field==null?row1.field"+row1.filed.replace("-","")+")"): row1.filed

Re: Project scenarios

manodwhb — Tue, 19 Jun 2018 11:07:57 GMT

try the below one.

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")?(row1.field==null?row1.field:"("+row1.filed.replace("-","")+")"): row1.filed

Re: Project scenarios

Darmesh — Tue, 19 Jun 2018 11:12:04 GMT

it has null values.

error :

java.lang.NullPointerException

Re: Project scenarios

manodwhb — Tue, 19 Jun 2018 11:19:16 GMT

this should fix for the null pointer exception row1.filed

if you still gets you have look for other columns may be causing null pointer exception.

!row1.filed.equals("") || row1.filed!=null||row1.filed.contains("-")?"("+row1.filed.replace("-","")+")": row1.filed

Re: Project scenarios

Darmesh — Tue, 19 Jun 2018 11:31:01 GMT

still the same error.

But i want to load the null values into the excel without getting null exception error.

Is there any other method to convert negative values to () brackets.

Re: Project scenarios

manodwhb — Tue, 19 Jun 2018 13:36:09 GMT

@Darmesh, i am able to get with below expresion. please check

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