Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Hello All 

 

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

 

Thanks In Advance 

Manish

Labels (3)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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

View solution in original post

5 Replies
TRF
Champion II
Champion II

row1.myColumn.replaceAll("\"", "").replaceAll("'", "").replaceAll(",", ""))
Anonymous
Not applicable
Author

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

TRF
Champion II
Champion II

This one much more better:

row1.myColumn.replaceAll("[\"',]", "")
Anonymous
Not applicable
Author

@TRF thanks I have tried this, it works 

talendtester
Creator III
Creator III

@Fred Trebuchet​ For tBigQueryInput I ended up with:

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