Forum Discussion
Double Quotation (") - Identification and Removal
Hi Pat,
I ended up using a few different steps to try to clean the double quotation marks. One thing that I ended up doing was using the text replace function, pointing it to my column and replacing a set of double quotes written as "" with nothing (using the quote structure of M code) "" so the actual step in my query looks like this:
= Table.ReplaceValue(#"Replaced Value","""","",Replacer.ReplaceText,{"MyColumn"}) I guess our takeaway here is to replace a double quote character we need to specify a set of double quotes within the M code so power query understands what we are replacing, like escaping a character in other languages/expressions.
One thing to try would be to find a cell that has the character and click on it in the query editor. You then see the value in the preview window below where you can select that character, copy it, and paste it into the Replace values pop up.
Pat
Hi Pat,
I ended up using a few different steps to try to clean the double quotation marks. One thing that I ended up doing was using the text replace function, pointing it to my column and replacing a set of double quotes written as "" with nothing (using the quote structure of M code) "" so the actual step in my query looks like this:
= Table.ReplaceValue(#"Replaced Value","""","",Replacer.ReplaceText,{"MyColumn"}) I guess our takeaway here is to replace a double quote character we need to specify a set of double quotes within the M code so power query understands what we are replacing, like escaping a character in other languages/expressions.