topic Re: Remove $ and comma in String in Talend Studio

Remove $ and comma in String

Karuetl — Mon, 08 Apr 2019 22:13:55 GMT

I receive in the comma separated file as below

111,Jake,"$1,320.00 "
22,John,$128.00

I gave below to remove $, it didn't help me as it gave output as "1

row5.column.replaceAll("\\$", "")

michad — Mon, 08 Apr 2019 23:26:27 GMT

Hello,

You can use the component tReplace like this :

Hopefully it will help you.

Karuetl — Mon, 08 Apr 2019 23:43:21 GMT

file is a comma separated

Karuetl — Tue, 09 Apr 2019 01:22:50 GMT

Hi

I receive in the comma separated file as below
111,Jake,"$1,320.00 "
22,John,$128.00

michad — Tue, 09 Apr 2019 08:13:11 GMT

To do this, you must use component tFileInputDelimited to cut your line according to a field separator.