Text editor with syntax highlighting, theme support and code folding

Question

I have a table

MissingData

1
10
NULL
NULL
22
NULL

The desired output will be

MissingData

1
10
10
10
22
22

i.e. the nulls will be filled up by the previous value until a new value is appearing.

I can solve this by using loop but my requirement is to solve it by CTE in which I am not so comfortable as of now.

Thanks

Solution 1

I would think gedit would be perfect. It is on Ubuntu by default, is easy to use, and can be extended with plugins.

That being said, since notepad++ is based on scintilla, scite is probably worth checking out. Scite is based on scintilla as well, though as fred.bear points out, it might be less feature-rich than you need.

Here are a couple more:

jEdit

jedit - A plugin-based editor for programmers

jEdit is a powerful open source editor [...] unlimited undos/redos, syntax highlighting for more than 130 file formats, markers for fast and easy navigation, online help, bracket matching for programming languages as well as auto-indent. Plugins can be downloaded and installed from within jEdit using the "plugin manager" feature.

vim / gvim / cream

gvim or cream - VI IMproved, with optional VIM macros that make the VIM easier to use for beginners

Solution 2

Without GUI or with a simplified GUI (still needs to be run in terminal):

• vi

• vim

• nano

• ed

• pico

• emacs

• xemacs

With GUI:

• geany

• mousepad (default under Xfce)

• kate

---

Please note that some of these programs may not be available from Ubuntu's official repositories.

Solution 3

Try Bluefish, Geany, or even installing Notepad++ trough Wine if you want.
More on installing Wine on Ubuntu and one example of installing some application using Wine.

Solution 4

I'm an ex Notepad++ devotee!!!! It was hard making the shift to "nowhere land" after knowing exactly how to do things in Npp, but I've gradually discovered that with the right plugins and a few personal scripts which you can easily add via the External Tools plugin, that gedit is the easiest and best transitional editor for hard-core ex- Npp users. I feel your pain ;)

After 4 months of Linux, I'm starting to get a good feel for things, and I'm branching out to GNU emacs because it leaves Npp standing still (really Npp's regex sucks!) I've tried gvim and it seems very good too, but a few things about emacs gel better with me...

gedit with plugins is quite a good choice once you get to realize that this Ubuntu thing is a whole new world... so you need a matching editor... I've got Npp installed in wine for a sense of security, but I virtually never use it anymore, because gedit is basically just as good... and GNU emacs and Gvim are better (but they have a big learning curve) go for gedit.

You may be interested in running Notepad++ in wine (I was)... so here are some notes I've put together about the bugs I've found using Notepad++ in wine...

• notepad++ - Wine-BUGS - Ubuntu.10.04

Solution 5

I've been using the Sublime Text 2 alpha on Ubuntu and enjoy it a lot. It's nice to have the same editor across multiple OS's

View more solutions

Comments

[belacqua]

useful requirements could include things like syntax highlighting for lanugage X, theme support, line numbering, code folding, regex style.

[Thinking]

But your query has failed for declare @orderedset table(ordinal int not null, value int null) insert into @orderedset(ordinal, value) values (1, 65) insert into @orderedset(ordinal, value) values (2, 15) insert into @orderedset(ordinal, value) values (3, 69) insert into @orderedset(ordinal, value) values (4, NULL) insert into @orderedset(ordinal, value) values (5, NULL) insert into @orderedset(ordinal, value) values (6, NULL) insert into @orderedset(ordinal, value) values (7, 36)

[Thinking]

The output is filled value ------------ 65 65 69 69 69 69 69 instead of 65 15 69 69 69 69 36

[Paul Keister]

Good point, my original code has assumed the values would always increase. It's fixed now.

[mathepic]

ed? Ha! Real programmers use cat.

[Pedram]

Yeah, gedit is awesome.

[Ragnar123]

Another example of a editor with GUI could be gVim, or vim-gnome, as I think the package is called

[Peter.O]

That's the joke.. A REAL programmer is so good, he gets it right the first time ;)

[Peter.O]

Scite/Scintilla is basically a no-features editor... Massive work has been done by the Npp crew to supercharge it... (but it still only has a nominally useful single-line-only reg-ex) .. forget Scite/Scintilla ..

[belacqua]

@fred I defer to you on scite versus Npp, but since I'm not clear on our OP's actual requirements, I'm leaving scite in my answer for now. Having used strictly vi without extensions to do important work, I have a pretty expansive view of what can be useful. (*important work such as writing crappy perl code)

[belacqua]

Also, I was going to link larger images from the thumbnail images, but I haven't found a way to do that.

[Peter.O]

I had forgotten about Cream... I had tried and it was very tempting.. but I decided to not use it.. basically because it kept me from learning vim's native keyboard style (which is where vim shines.. once you've re-trained your habits) .. but, yes it certainly has that stanard windows feel (which an Npp user is used to), and lots of power... a good candidate..

[MestreLion]

@papukaija: how dare you say such heresy??? Of course cat is an editor. Actually, it's the only editor real men need: cat > myfile.c. Type in your code, CTRL+D to save. Who needs more?

[Gabriel Staples]

On Xubuntu, mousepad has syntax highlighting and a lot of features for a light editor. It comes as the default editor for Xubuntu. On Raspbian, however (for Raspberry Pi), after I installed it (sudo apt-get install mousepad), mousepad has nothing. It's a bare-bones editor. How do I get syntax highlighting added for it in Raspbian?

[Gabriel Staples]

@papukaija (or someone else), can you edit this post to put an asterisk or something by all of the text editors in the list with syntax highlighting?

[ZEE]

REAL PROGRAMMERS USE > and >>.... and cat... ;-)