Forum Discussion
Solved
How to append quotation marks to a text string?
Hi All, I have successfully used the combine.text function to adapt my incoming data stream into the format I want and this is going great, but I have a specific text string which I need to append a...
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 """", which just so happens to be the string with which your "text" string should be replaced.