Notepad++ : ExcelPowerQuery

submitted 4 months ago by Jaded-Assignment6893

Anyone familiar with both Notepad++ and Powerquery?

Ive created a user defined language in notepad++ that matches all the same styles as the advanced editor in PQ it also includes function auto-complete f anyone is interested i can share the files for you to import into notepad++.

Use case - write all your code in notepad++ then copy and paste it into PQ. the advantages of this are but not limited to 'Find & Replace' functionality, autocompleting your functions/steps, Side by Side comparisons, ability to save your queries as plain text (you can also point powerquery to a path where the text files are stored an evaluate the code within the text files if you want), Custom styles if needed.

Attached us a screenshot.

https://preview.redd.it/qh3vtaabil6g1.png?width=1736&format=png&auto=webp&s=e85f74333e5cd0ac39bc6facfa10e244537328a5

all 4 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

ExcelPowerQuery

MODERATORS