Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 quotation mark to, but I can't work out the syntax to do so.
All I need is the ability to change 123 to be 123"
What is the syntax for treating a quotation mark as a text string?
so I can write
Text.Combine({[#"raw_width"],"text"},"")
which gives me 123text as an output
but what can I replace "text" with in order to give an output of 123" ?
thanks in advance,
James
Solved! Go to Solution.
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".
How to append quotation marks to a text string while using Push Data API ? I am gettiing Bad Request message.
Convert double quote into %22 while hitting the url
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".
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!
works perfect 🙂 thanks for your help,
J
You're welcome. Glad I could help.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
54 | |
53 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |