SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 At the risk of being sacrilegious...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 09/25/2012 :  11:53:22  Show Profile  Reply with Quote
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

USA
15659 Posts

Posted - 09/25/2012 :  12:02:43  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 09/25/2012 :  13:40:20  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15659 Posts

Posted - 09/25/2012 :  13:48:26  Show Profile  Visit robvolk's Homepage  Reply with Quote
Looks like just generic, but you can define your own: http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2019 Posts

Posted - 09/26/2012 :  01:55:05  Show Profile  Visit jackv's Homepage  Reply with Quote
Programmers Notepad is excellent with loads of plugins - re: different lanaguages

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 09/26/2012 :  11:22:43  Show Profile  Reply with Quote
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
Go to Top of Page

lazerath
Constraint Violating Yak Guru

USA
328 Posts

Posted - 10/02/2012 :  15:51:24  Show Profile  Reply with Quote
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.
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/05/2012 :  01:47:34  Show Profile  Visit jezemine's Homepage  Reply with Quote
+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
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 10/08/2012 :  11:23:51  Show Profile  Reply with Quote
I use Notepad++ too

Back 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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000