Beast mode to remove "double quotes"?

CR123

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.

MarkSnodgrass

I think you might want to do some troubleshooting to see what is actually in there. I would suggest creating a beast mode that uses the INSTR() function will return the character number for the searched character. I think you should look for a single quote and as well as a full quote.

To look for a full quote use this: INSTR(ClientName,'"')

To look for a single quote, you need to enter two single quotes within the outer single quotes, like this:

INSTR(ClientName,'''')

Drag this beast mode into your table card and see which one returns a number other than zero. This will help you know what is in your client name field.