Highlighting of line comments (//) and block comments (/* */).Highlighting of all current (v11.20) keywords and statements.Highlighting of all current (v11.20) functions.It currently supports the following features: The syntax highlighting that is provided is limited to the capabilities of Notepad++ Custom Language Definitions and Auto-Completion files, and is an approximation of what you would get in QlikView's Edit Scriptĭialog.

You can download xlf_udl.The Qlik Custom Language Definition for Notepad++ gives basic syntax highlighting, auto-completion and code tool-tips when working with QlikView and Qlik Sense script files in Notepad++. I don’t know if I would have had the patience to put all those function names in there. By the way, thanks to Bob for doing all the hard work on this. If you like this folding option, you can import my UDL xml file instead of Bob’s. I pasted the above formula back in Excel and it retains the line breaks. But I think the next time I start counting parentheses I’ll pull this up and save myself some trouble. It remains to be seen if I’ll use it as a formula editor. Happily, the intellisense portion works with Folder Open Keywords just like for Keywords. I like the folding option this provides and it eliminates the problem with FALSE being interpreted as a function name when it’s used as an argument. I ended up appending an open paren to the function names and using that as Folder Open Keywords. Not the worst thing in the world, but not would I would do intuitively. That still may be a better option, although it would require that I consistently line break before the open paren rather than after. However, it seems to require a space before the open parenthesis or to have it start a line to work. Then I thought that simply having an open parenthesis as the only Folder Open Keyword would be even better. That worked OK, but didn’t work well with FALSE as FALSE is both a potential argument and the name of a function. I started by trying to make all of the function names Folder Open Keywords and a close parenthesis as the Folder Close Keyword. Folding is collapsing certain portions of the code so the rest is easier to read. The only thing I don’t like about it is the folding option.

I downloaded Notepad++ and Bob’s xml files and gave it a try.

He uses a custom language in Notepad++ to allow for indenting formulas, editing formulas, and all the other stuff you can do in a text editor that you can’t do in Excel’s formula bar. Bob wrote a blog post last week, Formulas Made Easy, that I read with great interest.

Xml formatter notepad++