Forum Discussion
How to append quotation marks to a text string?
In Power Query, the escape character for a quotation mark inside a string is represented as ""(two quotation marks).
For example, a string containing a single quotation mark would be written as
""""
(four quotation marks), which just so happens to be the string with which your "text" string should be replaced.
EDITED:
Apparently, you can't post here four quotation marks in a row outside of a "code element".
In Power Query, the escape character for a quotation mark inside a string is represented as ""(two quotation marks).
For example, a string containing a single quotation mark would be written as
""""
(four quotation marks), which just so happens to be the string with which your "text" string should be replaced.
EDITED:
Apparently, you can't post here four quotation marks in a row outside of a "code element".
works perfect :) thanks for your help,
J
You're welcome. Glad I could help.
Note that the results of copying from the Power Query preview grid will be wrapped in double-quotes. I found copying from the preview pane at the bottom worked better for me when testing. Thanks for the answer above!
