topic Re: How to remove quotes, double quotes and commas in tMap with one function in Talend Studio

How to remove quotes, double quotes and commas in tMap with one function

Anonymous — Sat, 16 Nov 2024 04:17:21 GMT

Hello All

I have a requirement How to remove quotes, double quotes and commas in tMap with one function

Thanks In Advance

Manish

TRF — Wed, 23 Oct 2019 14:40:31 GMT

row1.myColumn.replaceAll("\"", "").replaceAll("'", "").replaceAll(",", ""))

Anonymous — Wed, 23 Oct 2019 15:18:19 GMT

@TRF Thank you so much, it worked for me to remove comma, quotes and double quotes

TRF — Wed, 23 Oct 2019 15:43:01 GMT

This one much more better:

row1.myColumn.replaceAll("[\"',]", "")

Anonymous — Wed, 30 Oct 2019 17:50:01 GMT

@TRF thanks I have tried this, it works

talendtester — Fri, 15 Sep 2023 20:54:56 GMT

@Fred Trebuchet For tBigQueryInput I ended up with:

,REGEXP_REPLACE(myColumn,'([\"\\',])',' ')