Remove $ and comma in String

[Karuetl]

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 · Accepted solution]

Hello,

You can use the component tReplace like this :

• Uncheck simple mode and active advanced mode
• In the column Pattern, copy the following regex : "\\$|,"
• Put empty string in column Replace

Hopefully it will help you.

[Karuetl]

file is a comma separated 

[Karuetl]

Hi

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

[michad]

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

You can find documentation of this component here : https://help.talend.com/reader/8BHX9tH5qcw~5xM6p58OTg/wZphtUXJPNp32p65z7XSgQ