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.

GrantSmith

You should be able to just use the REPLACE function like you mentioned:

REPLACE(`Client Name`, '"', '.')

How is your beast mode not working? What are you getting and what are you expecting?

CR123

https://community-forums.domo.com/main/discussion/comment/99255#Comment_99255

Sorry, should have described that in the original post.

If I have a string like Grant "Coach" Smith in my column named Client Name, I expected this Replace function would have resulted in Grant .Coach. Smith. It is still Grant "Coach" Smith.

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.