topic Re: QlikView in Notepad++ in QlikView

QlikView in Notepad++

Mon, 30 Apr 2012 15:46:02 GMT

After finding broken links for other posts about QlikView syntax highlighting in Notepad++ I created a basic Notepad++ language definition myself and thought I'd share it. Its far from perfect but it but it does the basics and makes working with .qvs files in Notepad++ a bit easier. Details and links here http://www.qlikviewaddict.com/2012/04/qlikview-scripts-in-notepad.html

Regards

Matt

QlikView in Notepad++

Fri, 04 May 2012 08:50:57 GMT

I've released an updated version of the language definition that should now support all keywords, statements and functions as well as line and block comments. Details and links here http://www.qlikviewaddict.com/2012/05/qlikview-for-notepad-update.html

Regards

Matt

QlikView in Notepad++

Fri, 08 Jun 2012 11:50:42 GMT

I've released version 0.3 which removes the escape character "\" from the language definition as it isn't needed for QlikView syntax highlighting and caused issues if the "\" appeared in the script. Details and links here http://www.qlikviewaddict.com/2012/06/qlikview-for-notepad-update.html

Regards

Matt

Re: QlikView in Notepad++

Mon, 12 Nov 2012 16:50:53 GMT

Version 0.4 is available. A few minor changes and improvements. Download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

Regards

Matt

Re: QlikView in Notepad++

Mon, 10 Dec 2012 13:51:33 GMT

Since I've had no reports of issues I'm now releasing Version 1.0. A few minor tweaks have been included in this release that weren't in version 0.4. Most notably "REM" was removed from the keywords list to prevent incorrect highlighting of it. Download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

Regards

Matt

Re: QlikView in Notepad++

Mon, 20 May 2013 10:15:52 GMT

I've released a new major update (version 2.0) with the following improvements:

Improved code section folding
Improvements to keyword combinations to prevent incorrect highlighting (eg. INFO should not be highlighted unless it is followed by LOAD of SQL)
Added missing "GROUP BY" keyword
Number formats support hex even though no formatting is shown for numbers within QlikView by default (prevents correct highlighting if appears in a string).
Auto-completion of all keyworods and functions
Tool tips shown for most commonly used functions (including colour, string, aggregation, numeric, inter-record and many other functions).

As before, download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

Regards

Matt

Re: QlikView in Notepad++

Thu, 11 Jul 2013 10:35:41 GMT

Notepad++ version 6.4.1 was released recently and contains some exciting new additions.Top of the list is the new function list which has been awaited for a while now and is a popular feature in many other code editors (including UltraEdit).

Because of these changes I've released a new version of the QlikView language definition v2.1 to support them where possible. This is another significant update and includes:

New function list support allowing Notepad++ to show subroutines, qualify and unqaulify statements, table loads, info loads, mapping loads and store statements all identified within the function list.
Removed some functions from the auto-complete file as they are only valid in expressions not the script.
Changed priority of highlighting to fixed issue with some keywords not highlighting correctly
Fixed some minor issues with keywords being highlighted when they were shown in the wrong positions.
Added tool tips for some additional functions.

This version has the following known limitiations:

The if() function cannot be differentiated from the IF...ENDIF statement and thus will be shown as a collapsible block with an incorrect end point.
Tool tips are not available for all functions. Remaining functions to be added in a future release.

As usual, download links and instructions available here http://www.qlikviewaddict.com/p/qlikview-notepad.html

Re: QlikView in Notepad++

vadimtsushko — Fri, 29 Aug 2014 06:47:04 GMT

Hi Matthew.

Do you consider registering your plugins on http://branch.qlik.com/projects ? It would be great, I believe

Best regards, Vadim

Re: QlikView in Notepad++

Sun, 31 Aug 2014 21:33:32 GMT

Hi Vadim,

It is my intention to get both the Notepad++ and UltraEdit language definitions up on Branch when I get a few spare minutes. I'll post here when I do.

Regards

Matt

Re: QlikView in Notepad++

Mon, 29 Sep 2014 14:31:22 GMT

I've just released a new version of the QlikView Notepad++ Language Definition. Version 2.3 contains the following minor fixes/functionality:

Solved an issue with correct highlighting of nested function calls. Added comma "," as an operator to correct issue with function names not being highlighted correctly when it immediately follows a comma inside another function call.
Added missing function tool tips. All functions should now provide both auto completion and tool tips.
Removed the ability to fold IF statements because of an issue where Notepad++ tries to collapse if() functions which causes the collapsing to fail.

Additionally, I have moved the project to GitHub and have added it to http://branch.qlik.com/ too. As always, head over to the Notepad++ Language Definition page (or Branch) for the download link and instructions.

Regards

Matt

Re: QlikView in Notepad++

Tue, 06 Jan 2015 16:13:39 GMT

Great job Matthew, thanks a lot for this.

Re: QlikView in Notepad++

Wed, 07 Jan 2015 10:19:37 GMT

Glad you like it Ricky!

Re: QlikView in Notepad++

agomes1971 — Wed, 07 Jan 2015 10:23:04 GMT

Hi,

great job out there!!!

Regards

André Gomes

Re: QlikView in Notepad++

Wed, 07 Jan 2015 10:25:01 GMT

Thanks André!

Re: QlikView in Notepad++

Mon, 23 Feb 2015 23:33:47 GMT

A new version of the QlikView Notepad++ Language Definition has been released to correct some minor issues. Version 2.4 contains the following minor fixes/functionality:

Added the missing keyword "IN"
Added the missing function "filelist()"
Other minor code improvements.

As always, head over to the Notepad++ Language Definition page on QlikViewAddict.com (or Branch) for the download link and instructions. New versions of my other syntax highlighters to follow shortly.

Re: QlikView in Notepad++

cotiso_hanganu — Wed, 02 Sep 2015 08:36:59 GMT

Hi Matthew,

A great job you have done with this Notepad++ extension !

Thank you !

Re: QlikView in Notepad++

cotiso_hanganu — Wed, 02 Sep 2015 08:50:06 GMT

A short comment on an issue I've faced recently:

Trying to read QVC.qvs with Notepad++ I've noticed that the Fold All command (and others around the collapse functionality ) in Notepad++ is acting a little bit strange in the following directions:

1. "Fold All" (over QVC.qvs), should show almost only SUB rows. (Perhaps some additional global variable definitions.)

Well, if you look at the very first SUB AsOfTable, it seems that some of the rows are not collapsed as it should.

2. I've noticed FOR is collapsable, but IF it's not.

Is this work as intended ? Can also IF become collabsable ?

Considering you had an important impact on QVC development, I thought this input can be relevant for you.

A feedback from you will be highly appreciated.

Sempre fi,

Cotiso

Re: QlikView in Notepad++

Jason_Michaelides — Thu, 03 Sep 2015 10:23:45 GMT

Awesome job Matt - extremely useful.

Thanks!

Jason

Re: QlikView in Notepad++

Anonymous — Mon, 30 Jan 2017 17:05:48 GMT

Thanks, Matt! Really useful for me.

Re: QlikView in Notepad++

ahaahaaha — Tue, 31 Jan 2017 08:44:24 GMT

Thanks, good work.