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.
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.
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.