I have some strings in a column named Client Name column that include double quotes ("). Need to remove or replace them.
I tried using the REPLACE function to replace them with dots like so: REPLACE('Client Name','"','.').
Most things I've found when trying to look this up were more advanced requests and I have not been lucky in adapting those solutions to this seemingly simpler problem. Maybe this is a job for ETL? I am using ETL to merge two data sets together for this card.