Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
I have a requirement How to remove quotes, double quotes and commas in tMap with one function
Thanks In Advance
Manish
row1.myColumn.replaceAll("\"", "").replaceAll("'", "").replaceAll(",", ""))
row1.myColumn.replaceAll("\"", "").replaceAll("'", "").replaceAll(",", ""))
@TRF Thank you so much, it worked for me to remove comma, quotes and double quotes
This one much more better:
row1.myColumn.replaceAll("[\"',]", "")
@TRF thanks I have tried this, it works
@Fred Trebuchet For tBigQueryInput I ended up with:
,REGEXP_REPLACE(myColumn,'([\"\\',])',' ')