Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |