Forum Discussion

DWJames's avatar
DWJames
Regular Visitor
10 years ago
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...
Need Help
  • itayrom's avatar
    itayrom
    10 years ago

    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".

itayrom's avatar
itayrom
Resolver II
10 years ago

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".

kfasick's avatar
kfasick
New Member
3 years ago

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!