| Author |
Topic |
|
Jake Shelton
Yak Posting Veteran
74 Posts |
 Posted - 2012-09-25 : 11:53:22
|
| Anyone know of a good (and free!) text editor? This is inspired by a recent personal requirement to chop up and reformat some data, just 25 lines or so, too small to create an entire package in IS for, but it occurs to me that as a DBA, I ought to have a good editor to prep data for SQL. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-25 : 12:02:43
|
| Notepad++ is the standard for free. I believe UltraEdit and Editpad also have free versions. If you're hardcore you can also go Vim or Emacs. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-09-25 : 13:40:20
|
quote:
Originally posted by robvolk
Notepad++ is the standard for free. I believe UltraEdit and Editpad also have free versions. If you're hardcore you can also go Vim or Emacs.
Does Notepad++ support TSQL, or just generic SQL?CODO ERGO SUM |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-25 : 13:48:26
|
| Looks like just generic, but you can define your own: http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-26 : 01:55:05
|
| Programmers Notepad is excellent with loads of plugins - re: different lanaguagesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-09-26 : 11:22:43
|
| You may at the SSMS Tools Pack to see if it can do what you want.http://www.ssmstoolspack.com/It's free for versions before SQL Server 2012.CODO ERGO SUM |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2012-10-02 : 15:51:24
|
| I use the Programmer's File Editor, which is old school but free. It has a very rudimentary but effective macro feature and allows globally replacing things like newline (\n) and tab (\t). I wish the macroing supported more advanced features, but I have found it fast and efficient for my needs. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2012-10-05 : 01:47:34
|
+1 for notepad++used emacs back in my linux days. when I first started with windows I tried to keep using it but it was weird to use it on windows. it's a great editor. can also use it as a cmd shell. escape-meta-alt-ctrl-shift.
elsasoft.org |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-10-08 : 11:23:51
|
| I use Notepad++ tooBack in the day I used a variant of emacs called microemacs which, rather scarily, is apparently still around.steve-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
|
|
At the risk of being sacrilegious...