I've tried using REPLACEALL and am not having much luck as I do with other characters. Does anyone know how I can clear a string containing these characters " \
Double quotes (") isn't considered a special character and the REPLACE[ALL] should be acting as expected. I don't have any data readily available to test from a column perspective. Using hardcode values in an example:
SELECT REPLACE('te"st"', '"', '') FROM [All]
The issue with the backslash is it needs to be prefixed with another backslash \\. Using hardcode values in Query Admin produced an error message. In your REPLACE statement, can you try '\\' (REPLACE([attribute],'\\',''))? It might interpret the need to replace the double backslash, not interpret \.
So the \\ worked and actually removed the quotes as well (maybe Birst wraps the string in double quotes if it has special characters?). Thanks!
