Forum Discussion

CJS1199's avatar
CJS1199
Frequent Visitor
2 years ago
Solved

Pasting code back into Power Query, double quotation marks not pasting properly

So I was creating a new custom column, based on one I created in another source, and I took the original code into Word for easy finding/replacing of certain pieces to create the new one. When pastin...
Need Help
  • dufoq3's avatar
    dufoq3
    2 years ago

    If you want to write your code with another program, use notepad or Visual Studio Code with M Language installed (intelliSense included!):

     

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Hi CJS1199, it happens when you paste whole code into formula bar (I guess that you've copied whole query). You have to paste your code into Advanced editor.

CJS1199's avatar
CJS1199
Frequent Visitor
2 years ago

So because I made the changes in Word, when I paste the code into there I still run into the same issue. Here's what I'm seeing in the Advanced Editor. I can manually replace them, but we're talking tens of thousands at least haha. I should have provided a screenshot in the original post, sorry about that.