Credit: https://ssbi-blog.de/technical-topic...using-notepad/
What you need to do to get your Power Query Editor
Creating your own M editor in Notepad++ is not complicated and can be seperated in the following steps:
---
- Download Notepad++
- Creating Keywords highlighting via the GUI of Notepad++
- Adding parameter hints and help texts by using a specific XML file
Of cause you need to download the free tool Notepad++ (e. g. from here)
- Download Notepad++
---
- Creating Keywords highlighting via the GUI of Notepad++
After you installed the software you need to do some modification in Notepad++. Go to Language and choose Define your language…
The form for defining the user defined language opens. Choose Create New… and give your language a name. I called it M.
Now you have to define special keywords and their styles. Go to tab Keywords Lists and fill the first group with all the functions from Power Query. Open Keywords.txt (attached), select all (ctrl + a), then copy (ctrl + c), move to 1st Group in Notepad++ and paste all the function into that box (ctrl + v). The result looks like this:
Then press Styler and style the keywords as you like it. I decide turn all my function keywords in deep blue and bold letter.
Take care also to select the check box for prefix mode. That way your keyword only get styled, when it is used as a prefix. And now comes one of the most important steps: Don’t ignore case!
continue in next post...
Bookmarks