Use EditPlus to CSV a register

How to edit a course register into a spreadsheet

1. Copy paste register from browser into EditPlus
2. Use basic editing to remove dud lines
3. Find 'tab' characters and replace them with ',' and you have a basic CSV
4. Find '^\n' and replace with '' as a regular expression will remove blank lines.
5. Find '^    \n' and replace with '' as a regular expression will remove lines that appear blank but contain matching whitespace.
6. Alternatively Find '[    ]' where the square brackets contain a tab character and a space character (you can't just type a tab into the text box) and replace with '' as a regular expression will remove whitespace leaving truly blank lines.
7. Find '(000......)' and replace with '"\1"' as a regular expression, this will put full quotes around Banner IDs so they will be read as text.