topic Re: Insert Comma in Talend Studio

Insert Comma

Anonymous — Thu, 05 Mar 2020 07:36:56 GMT

Hi,

1)How to insert a comma in value?

IP: 35825 op:35,825

ip:3281564 op:3,281,564

2) How to replace the value -7.8 to (7.8)?

Kindly suggest.

Re: Insert Comma

manodwhb — Fri, 06 Mar 2020 03:22:39 GMT

@Learner2512 ,

1) if you were generating the output as file you can set the thousand separator in the advanced settings>>Advanced separator (for numbers) of tFileOutputDelimmited.

2) row2.newColumn.replaceAll("-","")