How to delete special characters in a cell.

Question

Hello folks,

I have a table with a bunch of text and in the text I have " characters, I need to delete them before I continue with my workflow.

Does anyone have any idea, I have tried REGEX function alwedy but it is not working as it does not accept """ Wording.

"Hello",0,"ciao",,,"bla",1574,"bla"

"Hello",10,,"hello2,,,123,"bla"

Thx for help

IraWatt · Accepted Answer

Hey @Timo97,

One non regex option is just to use the replace function like this:

replace([Column1],'"',"")

This will remove all the " from your text.