how to replace double qoutes ( " ) with space

[cristianj]

Hello

i am trying to replace from a column double quotes " 

first i try to use something like : substitute(mycolumn,"""," ")not worked, also i try to use "/"", try using a variable , tempvar=unichar(22), but nothing seems to work, 

Do you have any ideea? Thx

[Uzi2019 · Accepted solution]

Hi @cristianj 

you can either do it with power query
like below

Go to power query> select your column> select transform tab> select replace value> 

Put " in value to find and add single space replace with 

see above value is replaced with space.

you can try with dax also
create calculated column and write below dax

Replace dax = SUBSTITUTE(String[Column],""""," ")

I hope I answered your question!

[cristianj]

it's not working  😞

[AnalyticPulse]

can you share the snip of the column vaue that has  ''

[AnalyticPulse]

can you try below dax:
ReplacedColumn = SUBSTITUTE('mycolumn', "\"", "")

and can you show snip of the double quotes in data